Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

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

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';

 

req11.PNG

1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

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

QFabian_9-1621899880081.png

QFabian_10-1621899905331.png

 

QFabian_11-1621899915731.png

 

 

 

QFabian

View solution in original post

2 Replies
QFabian
Specialist II
Specialist II

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

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

QFabian_0-1621899305287.png

QFabian_1-1621899333739.png

QFabian_2-1621899355462.png

 

Then, group them :

QFabian_3-1621899418154.png

and again, group the third expression :

QFabian_4-1621899456860.png

 So, now you have 3 expressions grouped :

QFabian_7-1621899546339.png

And you can change the expression using the button :

QFabian_8-1621899599701.png

 

 

QFabian
QFabian
Specialist II
Specialist II

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

QFabian_9-1621899880081.png

QFabian_10-1621899905331.png

 

QFabian_11-1621899915731.png

 

 

 

QFabian

View solution in original post