Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a problem for the list box below,
In the list box have null value, how to auto hide the null value and then user just can select Mangement Expense and or OACQ
Thanks before.
Regards,
Valdi
Hi Valdi
QlikView should not display Null values in the list box selection. Could you try right clicking and exporting to excel to see if it is a space
You could fix this in the loadscript with something like : if(Field = ' ', Null(), Field) as Field
A better solution would be to fix it in the datasource
Many Thanks
Simon
That's not a null value, but an empty string or a value of one or more spaces. Listboxes don't show nulls. If you want to hide it then you need to use an expressions like =if(Len(Trim([Expense Type]))>0,[Expense Type])
A better solution is to replace that value in the script with a value like '<N/A>' or '<missing>'.
Hi Gysbert,
if I write the script =if(Len(Trim([Expense Type]))>0,[Expense Type]) in the tab sort --> expression
but still not work, the empty string cannot auto hide. just move to the bottom.
Yes, if you put that expression on the Sort tab you only change the sorting. That's why the tab has the name Sort. Go to the General tab and replace the field Expense Type with <expression> and then enter the expression I posted above.