topic Re: Null Handling in QlikView

Null Handling

sujeetsingh — Fri, 20 Sep 2013 11:08:00 GMT

Hello Guys,

I am facing an issue :

I have Date as Dimension and i use expression Sum(Sales)

Now i want the exclusion of Brand Type in the expression.

as Sum({<Brand Type=->}Sales)

Now earlier i was having only data for dimensions available with value .

but now after using the set analysis i get a date added and have Value - (null)

Note:

---I have checked all options with Supress missing and null.

Thanks

Re: Null Handling

tresB — Fri, 20 Sep 2013 11:19:30 GMT

Not very clear about your issue. May be you can try to use a calculated dimension with set analysis and then use, 'Supress When Value is Null' in the dimension tab. Otherwise please share a sample app.

Re: Null Handling

sujeetsingh — Mon, 23 Sep 2013 06:02:29 GMT

I am using a group in dimension.

Seems experts are still away from the thread.