topic Re: Hiding the Expression in Pivot table in QlikView

Hiding the Expression in Pivot table

Tue, 17 Sep 2013 04:29:29 GMT

Hi,

I want to hide some of the expressions based on the level of expand dimensions.

when everything is collapsed i need to show only some of the expressions and when its expanded to next level i need to show all the expressions.

i tried with dimensionality function, but its not helping me.

could anyone help me to resolve this problem,

thanks in advance.

Re: Hiding the Expression in Pivot table

Gysbert_Wassenaar — Tue, 17 Sep 2013 09:28:49 GMT

What you want is not possible with a pivot table. There's no way to know (other than using your eyes) to know what is expanded or collapsed.

Re: Hiding the Expression in Pivot table

Tue, 17 Sep 2013 11:23:14 GMT

Hi Wassenaar,

Thanks for your reply.

I think its possible to find the level of expanded using dimensionality() or secondarydimensionality function.

I dont know how yo use that functions in conditional location. i can able to use dimensionality in expression tab. its working fine. but in conditional, its not working.

Re: Hiding the Expression in Pivot table

yevgeniy — Fri, 20 Sep 2013 13:41:37 GMT

Hi Gopinathan,

May be i do not understand you question .

But, conditional is work:

if(Dimensionality()<3,

Sum ({$<PYD= {2} , Date2 = {'<=$(vVitorg)'}>}[Sales])-Sum ({$<PYD= {2} , Date2 = {'<=$(vVitorg)'}>}[Sales]),

if(Dimensionality()<5,

Sum ({$<PYD= {1} , Date2 = {'<=$(vVitorg)'}>}[Sales(чеки)])-Sum ({$<PYD= {1} , Date2 = {'<=$(vVitorg)'}>}[Sales]),

Sum ({$<PYD= {1} >}[Sales]) - Sum ({$<PYD= {1} >}[Sales]))