topic Calculation Condition for a chart in QlikView

Calculation Condition for a chart

Wed, 23 May 2012 16:35:10 GMT

Hi,

I have a bar chart with three expressions; total charges, total payments and total account balance. My dimension is country name.

I would like to add a calculation condition to a chart that says only pull in charges and payments (already in chart) if the Hospital Account Status = Billed.

Do I add a Calculation Condition on the general tab of the chart? If so, should it read - If(Hospital Account Status="Billed").

Thanks in advance.

Calculation Condition for a chart

john_duffy — Wed, 23 May 2012 16:51:14 GMT

Hello.

A Calculation Condition is used to determine whether or not a chart is to be displayed.

If I understand your question correctly, you want to always display the chart but only total charges and payments if the Account Status = Billed. In that case you want to add a condition to your expression something like:

Sum(if(Acct_Status = 'Billed',Charges,null()))

John.

Calculation Condition for a chart

swuehl — Wed, 23 May 2012 16:57:29 GMT

The calculation condition will affect the complete chart, calculate yes/no.

If you want that,

if([Hospital Account Status] = 'Billed',1,0)

could do what you want.

Do you want to limit the two expressions to a subset of the data only, depending on Hospital account status?

For this, of your expression for charges is something like

=sum(Charges)

then change the expression to

=sum({<[Hospital Account Status]= {Billed}>} Charges)

and accordingly for payments.

This is a set analysis expression, you could also try

=sum(if([Hospital Account Status]= 'Billed', Charges))

Hope this helps,

Stefan

Calculation Condition for a chart

Anonymous — Thu, 24 May 2012 20:05:03 GMT

Hi Stefan,

If I use a conditional expression in a chart, my expression should work only when I select it in list box?

Do you know how to use set analysis or If condtional for all expression?

For example:

My main expression:

Count(B)*count(C)-count(D)*count(F)

It should be calculated only for A=aaa.

The result shold be the same as I use:

Count({<A={'aaa'}>}B)*count({<A={'aaa'}>}C)-count({<A={'aaa'}>}D)*count({<A={'aaa'}>}F)

Thanks,

Re: Calculation Condition for a chart

Wed, 10 Sep 2014 18:51:29 GMT

This is still tremendously helpful - Thank You.