Discussion board where members can get started with Qlik Sense.
Is it possible to write an expression in Total field of table object.
I have an table with 10 columns, i am displaying some values in columns also total at the bottom.
In one of the column i have values with % i need to show % in total by calculating it from the total of other columns.
A B C
2 2 1%
3 4 1%
5 6 6/5
Is it possible to get the total of Column "C" from the expression?
have you tried set the Totals function to None at settings? If not, try it
I need totals but in totals field i need to use expression only for some columns other column should display totals
Yes, you need it, I didn't say to turn it off.
You can set the Totals functions (or expression) by measures (sum, count, min, max, avg, none).
At the % maesure set this function to None.
Look into Dimensionality(), it can offer you the solution to just that:
How to use - Dimensionality()
The second dimension... or how to use secondarydimensionality()
Something like this: