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

[ashmitp869]

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]

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 · Accepted solution]

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%'))