Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Thanks. Got it.
IT IS QLIKVIEW
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
Thanks. Got it.