Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

No idea ?