topic Hide null rows at each dimension level in pivot table in QlikView

Hide null rows at each dimension level in pivot table

agni_gold — Fri, 06 May 2016 14:37:54 GMT

Hi All ,

I have one situation,

I am using pivot table , and it has 3 dimensions and one expression.

But i want to hide those rows which are null at the top level it is working fine like if i found null values in 2nd dimension this will work fine but if i got null value in 3rd dimension it is chaging my second level dimension total.

Can ypu please help me out here.

Thanks

Re: Hide null rows at each dimension level in pivot table

sunny_talwar — Fri, 06 May 2016 14:40:56 GMT

What is the expected output here?

Re: Hide null rows at each dimension level in pivot table

agni_gold — Fri, 06 May 2016 14:44:54 GMT

If i am suppressing null in 3rd column it will also suppress their respective number .

But i want here if i group at second level sum should 220 but if i un group 2nd level it should not show 130 value.

Re: Hide null rows at each dimension level in pivot table

sunny_talwar — Fri, 06 May 2016 14:52:33 GMT

Can you check now

=If(Dimensionality() = 2, Sum(four), Sum({<five = {'*'}>}four))

Re: Hide null rows at each dimension level in pivot table

agni_gold — Fri, 06 May 2016 15:04:12 GMT

thanks but at the first level sum should be 300 for B

Re: Hide null rows at each dimension level in pivot table

trdandamudi — Fri, 06 May 2016 15:07:06 GMT

Sunny,

Just for my knowledge purpose, What does the '*' represent ?

Re: Hide null rows at each dimension level in pivot table

sunny_talwar — Fri, 06 May 2016 15:07:54 GMT

I thought you would be able to play around with it to make it work according to your requirement.

Check this out

=If(Dimensionality() = 3, Sum({<five = {'*'}>}four), Sum(four))

Re: Hide null rows at each dimension level in pivot table

sunny_talwar — Fri, 06 May 2016 15:08:31 GMT

It means include all those five where they are not null

Re: Hide null rows at each dimension level in pivot table

trdandamudi — Fri, 06 May 2016 15:10:38 GMT

Thank you.

Re: Hide null rows at each dimension level in pivot table

ankit777 — Mon, 09 May 2016 07:21:46 GMT

Hi Agnivesh

Try something like this-file attached.