topic Hide null expression records in pivot table in QlikView

Hide null expression records in pivot table

Fri, 04 Sep 2015 01:00:01 GMT

Hi All,

I have a requirement where I have to show under performing stores for a month based on a sales condition.

I have attached a sample qvw with data. If user select a month, he should be able to see under performing stores for that month.

if sum(sales)<5 then store is consider as under performing store.

In my example if user selects feb month, he should see store s2, s3 however as per my expression, he is seeing s1, s2 and s3.

Please help me finding a solution for this requirement.

Thanks,

Anosh

Re: Hide null expression records in pivot table

karthikeyan1504 — Fri, 04 Sep 2015 01:33:10 GMT

Hi Anosh,

Please replace your dimension as =if(Aggr(Sales,Store)<5,Store,null()) instead of 'Store' and check suppress when value is null option.

Please find the attached qvw file.

Warm Regards,

Karthikeyan A R.

Re: Hide null expression records in pivot table

Fri, 04 Sep 2015 16:52:02 GMT

Hi Karthikeyan,

Thanks for your solution. It was quick. I just modified your calculated dimension as

=if(Aggr(sum(Sales), Store)<5, Store, null()) to get the correct result if 1 month is selected but if user selects more than 1 month or doesn't select any month, there is no data being displayed in chart. I would still want to show all under performing stores even if their sales are <5 for one month.

Thanks,

Anosh

Re: Hide null expression records in pivot table

stabben23 — Fri, 04 Sep 2015 19:37:24 GMT

Hi,

if you want to hide dimensions, use set analysis instead of trix with dimensions.

sum({$< Sales={"<5"}>}Sales) should do your jobb.