Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

Button

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?

2 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
pradosh_thakur
Master II
Master II

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

Learning never stops.