topic Re: condition calculation in QlikView

condition calculation

maniram23 — Mon, 11 May 2015 14:44:32 GMT

Hi experts,

what is conditional calculation ? when it is used ?

Re: condition calculation

mrossoit — Mon, 11 May 2015 14:48:44 GMT

Hi,

you can set an expression in conditional calculation editor so, when it's evaluation returns true, the chart will be calculated, else it will be shown a warning message in chart's plot area.

You can overwrite message in chart's properties -> General tab -> Error messages

Hope it helps

Regards

Re: condition calculation

datanibbler — Mon, 11 May 2015 14:49:20 GMT

Hi,

a conditional calculation is quite simply a calculation that you only perform if a specific condition is met - otherwise, you don't.

In QlikView, you can make pretty much everything dependent on conditions.

HTH

Re: condition calculation

Gabriel — Mon, 11 May 2015 14:55:57 GMT

Hi,

Having expression in Calculation Conditions means
the expression has to evaluate to TRUE before the chart displays information and if the condition is FALSE then
’Calculation condition unfulfilled’ is display.

When to use it varies. You can use it to pass info to user,
you can use it to count number of value selected in a field before displaying information.
There are various use cases, it depends on what you want to achieve.

Re: condition calculation

awhitfield — Mon, 11 May 2015 15:02:56 GMT

Hi Mani,

very simple example attached, the Table only calculates with the value A is selected in the Alpha List box

Andy