Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

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
Specialist
Specialist
Author

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Are you using QlikView or Qlik Sense?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

nevilledhamsiri
Specialist
Specialist
Author

IT IS QLIKVIEW

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist
Specialist
Author

Thanks. Got it.