Toggle button for billion/million/thousand

[vschowdary]

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.  

[Bunim]

a click on the button should change a variable from 1000 to 1000000 and the value will divide the variable.

for example: value/buttomVarible

[abhijitnalekar]

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