topic Re: Button to change absolute and percentile view in App Development

Button to change absolute and percentile view

Shaglok — Mon, 14 Mar 2022 23:39:09 GMT

Hi.

I am developing an app and I need to change very often between absolute numbers and percentiles in the tables. I think that a button would be an easy and elegant way to do it, but I don't know how to do that. Any advice, please?

Re: Button to change absolute and percentile view

Mario_Petre — Tue, 15 Mar 2022 08:35:59 GMT

Have you tried changing dimensions based on variables with a button? There is a "Set variable" action, which you could use. I also wanted to confirm this is for Qlik Sense Enterprise on Windows.

Re: Button to change absolute and percentile view

Or — Tue, 15 Mar 2022 08:41:51 GMT

1) Create a variable, e.g. vDisplayType and set its value to 0

2) Create a button that toggles this variable using a formula such as if(vDisplayType=0,1,0)

3) Within your master measures / expressions, you can refer to this variable, e.g. if(vDisplayType = 0,Sum(Value),Sum(Value)/Sum(Total Value)).

Alternatively, you can create two measures, add both to your table, and apply a "Show column if" condition to each one - one would be vDisplayType = 0 and one would be vDisplayType = 1. Note that this approach works fine for tables but is not available in most charts, iirc.