Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expression in Total field of table

Hi all,

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.

Example:

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?

Regards,

Pramod

4 Replies
undergrinder
Valued Contributor II

Re: Expression in Total field of table

Hi Pramodgc3,

have you tried set the Totals function to None at settings? If not, try it

G.

Not applicable

Re: Expression in Total field of table

I need totals but in totals field i need to use expression only for some columns other column should display totals

undergrinder
Valued Contributor II

Re: Expression in Total field of table

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.

G.

MVP
MVP

Re: Expression in Total field of table

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:

Capture.PNG