Saturday 17 September 2011

QlikView : Avoid NULL Value in Listbox

Add this function in ListBox Property function box,
Syntax:
=if(isnull(field name),'N/A',value or field name)

Example
=if(isnull(JA_LOCATION),'N/A',JA_LOCATION)

1 comment:

  1. Well, that’s really great and appreciated. Thanks for taking the time to discuss about QlikView , I feel strongly about it and love learning more on this topic. QlikView Training in Hyderabad

    ReplyDelete