Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selecting any record from pivot table hiding all the other data.

I want to show all the data in the pivot table even after selection of some particular data...

i am using this type of expression and it is not working:

=if(AncestorId='PAR007' ,prioryearfixed,

  if(AncestorId='PAR009',priorWorkingCapital,

  if(AncestorId='PAR010',priorOperatingWC,

  if(AncestorId='PAR011',priorCurrentRatio,sum({<str_pov_name={'ACTUAL'},str_fy={$(#vPriorYear)}>}money_measure)))))

where prioryearfixed,priorWorkingCapital,priorOperatingWC, priorCurrentRatio, vPriorYear are my variables consisting some expressions .

like =sum({<AncestorId={'BS02A','BS02B','BS02C'},str_fy={$(#vPriorYear)}>}money_measure)

and vPiorYear is =Num(str_fy)-1

so in this i was using sum({1} 0) with all the expessions but it is not working.

Please help.

Thanks.

0 Replies