Discussion Board for collaboration related to QlikView App Development.
How can I remove the particular value "(null)" from the 'Invoiced fees' and 'Project Type' column. Can it be done while loading the data or should I have to write certain expressions in the list box properties after reloading?? How to do it?
As I don't know the source of ur Data an alternative can be.
Suppose u have all ur data in a OldTable, Now u can write
Load FieldName1, FieldName2..... Resident OldTable Where IsNull(FieldName)=0;
or U can directly try using Where IsNull(FieldName)=0; after ur original Load Statement.
Thanks for the reply amars,
My source of the data is a .csv file.
And the (null) is not a 0 its actually a value "(null)" itself...i mean InvoicedFees='(null)'.
I tried IsNull(InvoicedFees)='(null)' but 0 lines are fetched as all the other columns which are associated to (null) are removed. But I want to remove only InvoicedFees which has (null) value.
And i dont want to format or filter in csv file, I want to do it in QlikView.
Hope you got my point!
Hi amars thank for your help..I solved it!
a simple where clause did the trick, I just misplaced ' ' as " ".