Allow user to change aggregations in a straight table

[#1]

I have a straight table that a user can select which dimensions and metrics will be shown in the straight table. The totals are by the expression. The user would like to switch between a sum and an avg depending on which metrics they choose. Is there an easy way to let them do this since they will not be able to access chart properties? Perhaps a quick toggle?

[maxgro]

switch the total (sum / avg) or switch the expression?

[MarcoWedel]

Hi,

maybe using expression grouping to switch between different expressions using a button in the chart header?:

hope this helps

regards

Marco

[#4]

Both

[#5]

This is a great idea and would work except I cannot change the properties of the group itself including adding a conditional statement which I have on the expressions but would like to have for the group too. For some reason those options get grayed out.

[qlikviewwizard]

Hi Mary,

Please close the thread by selecting Correct Answer and Helpful Answer if you get the solution.

Thank you.

[#7]

Yes, I will when do. Thanks.

[#8 · Accepted solution]

I ended up having to create another expression so the original is SUM() the new one is AVG(). There is not a way to group it based on my other requirements so unfortunately they are listed separately. This would be a great feature in a new release - to allow the user to specify and switch between different aggregations.

[maxgro]

PFA

[MarcoWedel]

You could as well use the same show condition on all grouped expressions to turn the group on/off:

hope this helps

regards

Marco