Button

[dandaanilreddy]

Hello Qlik Experts

I have a pivot table in which i am displaying the amount in millions. When i export to excel the values are showing in M like 100M. The users are asking to create a button where we can select the value as millions or complete amount.  Can someone help me please?

[vinieme12]

Give a list to toggle example

load * inline [

ShowIn,DivVal

$M,1000000    <<Millions

$K,1000          <<thousands

$,1                       <<As Is

];      

change expressions to refer to selected DivVal

examples Sum(Sales) / DivVal

[pradosh_thakur]

Create a variable v1 and set its value as zero.

Use the button to toggle the value of v1 between 0 and 1.

Create two columns one with M and another with complete count

Put conditional show hide for both as v1=0 for millions and v1=1 for complete count.

Now export to Excel.

Regards

Pradosh