Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vinay_hg
Contributor II

What if analysis in Qlik Sense - urgent

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..

q.JPG

2 Replies
vinay_hg
Contributor II

Re: What if analysis in Qlik Sense - urgent

please help..

priyasawant
Contributor

Re: What if analysis in Qlik Sense - urgent

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


Capture.PNG

Community Browser