topic Re: Variable Management to obtain a What if in QlikView

Variable Management to obtain a What if

cattaneoc — Sat, 22 Sep 2018 02:55:34 GMT

I have to put together a project where changing 'Variables' can be modifying values (for example in Simple Tables) to have an what if operative system.

My problem starts because Variables apply to database conditions (if).

I attach a very basic example with the explanation to make it clearer.

In the same happens that, with the formula that I created, it only works if all the fields are in the "Simple Table" but if I start to remove dimensions the formula does not work well anymore.

An alternative solution would be to create a "new" base (virtual without running the scrip) based on the Variables but I do not know if it can be done, if it exists, or there is surely a simpler solution!

Thank you very much

Carlos A. Cattaneo

Re: Variable Management to obtain a What if

lironbaram — Sat, 22 Sep 2018 04:09:09 GMT

in your case you must use aggr function , because if function is working by table row , so when Zona or Combustible

aren't part of the table they aren't conisdered for the calculation

using aggr function you basically create a virtual table for the calculation that adds the desired dimension to the table

have a look at the attach example

Re: Variable Management to obtain a What if

cattaneoc — Sat, 22 Sep 2018 15:04:40 GMT

works correctly!!

thank you very much!

Carlos