Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
vvvvvvizard
Contributor III

Custom Total row

I have a straight table with Multiple expression. When i click on a button i want the Total Column which is the first row on the top to show the sum of total , when i click another button i want to see the average of the Column for certain columns . 

 

 

1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Custom Total row

button1 -> on click ->set variable 1 = 1 and set variable 2 =0
button2 -> on click -> set variable 1 = 0 and set variable 2 =1

in the expression
=if (dimensionality=0,if( $(variable 2) = 1 , avgexpression ,sum expression), your expression)
Learning never stops.
1 Reply
pradosh_thakur
Honored Contributor II

Re: Custom Total row

button1 -> on click ->set variable 1 = 1 and set variable 2 =0
button2 -> on click -> set variable 1 = 0 and set variable 2 =1

in the expression
=if (dimensionality=0,if( $(variable 2) = 1 , avgexpression ,sum expression), your expression)
Learning never stops.