Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Exclude a particular value from the list

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 TypeDays-8HrDayDaysInvoicedFees
Time Off3.283.5
8888
Non-Chargeable8.59.07
(null)
(null)0.50.53
9999
Non-Chargeable7.57

(null)

3 Replies
amars
Valued Contributor

Exclude a particular value from the list

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....

Not applicable

Exclude a particular value from the list

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!

Not applicable

Exclude a particular value from the list

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

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