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

search a method to calculate total by row in pivot table

hello

i will try to explain my problem by example

i have a pivot table with 2 dimensions dim1 and dim2 and i have a "big expression 100 lines" exp1 and exp1=f(dim1,dim2)

you can see a example to my pivot table

dim1dim2B1B2Total
A1valuevalueexpTotal1
A2valuevalueexpTotal1
A3valuevalueexpTotal1
A4valuevalueexpTotal1
A5valuevalueexpTotal1
TotalexpTotal2expTotal2i search that

my expression in pivot table as like

if(isnull(dim1)=0 

     ,

     if(isnull(dim2)=-1 

          ,

           expTotal1

          ,

          exp1

     )

     ,

      if(isnull(dim2)=0

          ,

          expTotal2

          ,

          i search that with a expression function to expTotal1 or expTotal2

)

1 Reply
Not applicable
Author

No idea ?