topic Chart change depending on what measure (Number / percentage) user select in QlikView

Chart change depending on what measure (Number / percentage) user select

ashmitp869 — Thu, 20 May 2021 06:03:24 GMT

Hi there,

I have a requirement where a user can select the measure i.e show by Percentage or by Number .

How can I implement this :- How to show a user a chart depending on what he choose -

I am using variable like below :

set vDisplayedByShow='Number,Percentage';
set vDisplayedByShow='Percentage';

QFabian — Mon, 24 May 2021 23:40:27 GMT

Hi @ashmitp869 , one option is having more than one expression, and then group them :

First, create the desired expressions, in this case, 3

Then, group them :

and again, group the third expression :

So, now you have 3 expressions grouped :

And you can change the expression using the button :

QFabian — Mon, 24 May 2021 23:45:36 GMT

Other option is create a inline table:

ShowAs:
LOAD * INLINE [
ShowAs
#
%
];

and then use it inside the expression to change the formula :

if( ShowAs = '#', num(Sum (Quantity), '#,00'), num(Sum (Quantity) / Sum (total Quantity), '#,00%'))