Discussion board where members can get started with Qlik Sense.
I created a simple table as shown below, I need totals for some columns , for some other columns I do not need totals, how can I achieve this.
IN following example I do no wanna show any totals in "Final Profit or Loss %" column, I tried selecting "None" in Totals Function of this column still Qlik is showing something. Please help.
Try using the Dimensionality() function.
Change your expression from something like =sum(X) to =If(Dimensionality()>0, sum(X))
View solution in original post
If(Dimensionality()>0, sum(Final Profit or Loss %),'')
Which gives empty in the place of total.