Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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 ?