Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Motorsport28
Partner
Partner

"what if Analysis"

Hi Guys

Im working on a variable which i would like to increase my total revenue in percentage...I have been doing some searching and found a way to create a varable but it only increases my total revenue by values like 10, 20, 30 etc.. how do i change this to say 10%,20%

 

Thanks

 

1 Solution

Accepted Solutions
JordyWegman
Partner
Partner

Hi,

You can create a variable with a value of 0.2 (because 0.2 = 20%).

VariablePercentage = 0.2 (in variable overview)

Then you can create a button, or maybe a input box to change this value.

At last, use this variable in combination with your total revenue:

Sum([Total Revenue]) & $(VariablePercentage)

 Jordy

Climber

Work smarter, not harder

View solution in original post

4 Replies
JordyWegman
Partner
Partner

Hi,

You can create a variable with a value of 0.2 (because 0.2 = 20%).

VariablePercentage = 0.2 (in variable overview)

Then you can create a button, or maybe a input box to change this value.

At last, use this variable in combination with your total revenue:

Sum([Total Revenue]) & $(VariablePercentage)

 Jordy

Climber

Work smarter, not harder

View solution in original post

Motorsport28
Partner
Partner
Author

Thanks so much! 

Really appreciate it,

Worked!

JordyWegman
Partner
Partner

Great, good to hear! Good luck with it and please mark the post as solved!

Work smarter, not harder
Motorsport28
Partner
Partner
Author

I have tried but as soon as i click accept as solution it logs me out??