topic Re: How to exclude null in set analysis in QlikView

How to exclude null in set analysis

Mon, 11 May 2015 06:48:22 GMT

I have a list of account,Project id ,Amount etc.. there are few blank for Project id's ,which i want to exclude those blanks project ids in the set analysis

how to i do that ?

for example

Account	Project ID	Amount

8150	100XYZ	-42459
8150		-5195

i want to exclude -5195 value , how do i write in the set analysis ?

i tried using sum({<Project ID-={ ' '}>} Amount) but this set analysis is not working.

Re: How to exclude null in set analysis

Gysbert_Wassenaar — Mon, 11 May 2015 11:34:23 GMT

Try: {<Project ID={'*'}>} . That should filter out the nulls. If you want to filter out empty strings try {<Project ID-={''}>}

Re: How to exclude null in set analysis

sunny_talwar — Mon, 11 May 2015 12:06:21 GMT

Somehow for me * alone did not work. I always had to use {'*?'}. If what Gysbert‌ does not work, you can give this a try as well:

{<Project ID={'*?'}>}

HTH

Best,

Sunny