# New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Creator

## Data Scenarios

Hi,

I have a variable 'Months_to_Cancel' which tells me how many months a customer has stayed with the company before cancelling their membership.

I want to do a 'What if' to see how the Income would compare based on difference scenarios. So, if 6% of customers cancelled their membership after 1 month, the Income is 'x' (this would be actual amount).

However, what I want to do is have a play with the numbers so if I changed the 6% so say 3%, I want to know how much my income (variable 'Comp_total_net_income') would change within my KPI.

Any idea how I can do this please?

Creator III

I think I need more information; wouldn't the answer just be to take your monthly income and then x that by 6% (can make the % a variable); and then that is the factor with which your revenue would be reduced by.

Ie. if I have 100 customers paying \$10 / month; my monthly revenue is \$1000, if 6% of my customers cancel after 1month, my second month revenue is 6% less, 94 customers paying \$10/m = \$940 (6% less).

If thats what you are looking to do then may the % a variable - ie. vCancelPercent

then you can use this variable \$(vCancelPercent) in your KPI equation

Tags
Community Browser