topic Exclude a particular value from the list in QlikView

Exclude a particular value from the list

Wed, 09 Mar 2011 12:28:25 GMT

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?

Project Type	Days-8HrDay	Days	InvoicedFees
Time Off	3.28	3.5	8888
Non-Chargeable	8.5	9.07	(null)
(null)	0.5	0.53	9999
Non-Chargeable	7.5	7	(null)

Exclude a particular value from the list

amars — Wed, 09 Mar 2011 12:41:58 GMT

Hi Subhash,

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

NewTable:

Load FieldName1, FieldName2..... Resident OldTable Where IsNull(FieldName)=0;

Drop OldTable;

or U can directly try using Where IsNull(FieldName)=0; after ur original Load Statement.

Thanks....

Exclude a particular value from the list

Wed, 09 Mar 2011 12:56:25 GMT

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!

Exclude a particular value from the list

Wed, 09 Mar 2011 13:11:35 GMT

Hi amars thank for your help..I solved it!

a simple where clause did the trick, I just misplaced ' ' as " ".