topic What if analysis in Qlik Sense - urgent in App Development

What if analysis in Qlik Sense - urgent

vinay_hg — Tue, 04 Apr 2017 06:16:33 GMT

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

Re: What if analysis in Qlik Sense - urgent

vinay_hg — Tue, 04 Apr 2017 09:09:01 GMT

please help..

Re: What if analysis in Qlik Sense - urgent

priyasawant — Tue, 04 Apr 2017 09:41:54 GMT

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