Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nevilledhamsiri
Valued Contributor

What If Analysis

As per the data present below, please explain how I could set what if the Expenses, Claims & profits would be if the premium is varied?


    

Year Premium Fixed Expenses Claims Profit
2015 1,500,000              250,000       500,000            750,000
2016 2,000,000              350,000       450,000       1,200,000
2017 2,500,000              250,000       400,000       1,850,000
1 Solution

Accepted Solutions
nevilledhamsiri
Valued Contributor

Re: What If Analysis

Thanks. Got it.

4 Replies

Re: What If Analysis

Are you using QlikView or Qlik Sense?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

nevilledhamsiri
Valued Contributor

Re: What If Analysis

IT IS QLIKVIEW

Re: What If Analysis

You declare a field to be editable using the InputField script statement.  And then use the field in an expression with InputSum() or InputAvg() function.  You can also use the field in a TableBox where it is editable as a Dimension.

See the attached QVW for an example. When you hover over the Premium field in the table, click the arrow to edit the value. Right-Clicking the field offers some additional options.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

nevilledhamsiri
Valued Contributor

Re: What If Analysis

Thanks. Got it.