What if analysis in Qlik Sense - urgent

[vinay_hg]

Hi all,

In Qlik sense.

need to do what if analysis in table, like in a table multiple regions or countries will be displaying with revenue, need to enter the alter number region or country wise and see the individual variation and overall variation. variable or slider extension will not help me because it will take one value, and will not be dynamic against region/country.

below image

1. region & revenue from system.(in red

2. what if are entered numbers manually (in green)

3. altered revenue is calculated based on revenue + what if = altered revenue.

the what if numbers customer wants to enter / change manually to do the analysis.

please help..

[vinay_hg]

please help..

[priyasawant]

Hi you can write the expressions by creating a variable for the fields you need Whatif of and then accordingly write it in the straight table, please find the image as below.

sum(SalesAmount)+sum(SalesAmount)* $(vWhatif)/100