This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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';
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%'))
View solution in original post
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 :