Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have created normal table which contains measure and dimensions.
Now my requirement is need to divide the measure value based on the button.
If i select in thousands button then measure value should display "Value/1000" and
if click on millions button the it should display the 'value/1000000' and same for billions.
How can i achieve it in Qlik sense.
Thanks in advance.
a click on the button should change a variable from 1000 to 1000000 and the value will divide the variable.
for example: value/buttomVarible
Hi @vschowdary ,
You can set the same variable to all three table, which updates the variable value accordingly.
Eg. If a user clicks on a thousand button variable gets updated with 1000 same for million.
and you can use the same in the measure expression in the table.
suppose the variable name is Vconvert then expression will be valu/Vconvert