topic Sum with condition in expression of the bar chart. in QlikView

Sum with condition in expression of the bar chart.

Tue, 08 May 2012 18:47:02 GMT

Dear,
I need some help in expression chart.

My case:
I need to do a sum with condition on the bar chart.
For example:
I need to do the sum of the ITEM AOP and subtract the sum of ITEM ACT.
In this example the results must be 1.

ITEM	Value
ACT	100
ACT	20
ACT	40
AOP	110
AOP	21
AOP	30

Tks Regards

Sum with condition in expression of the bar chart.

Tue, 08 May 2012 19:02:30 GMT

Your expression must be:

Sum({<ITEM={'AOP'}>} Value) - Sum({<ITEM={'ACT'}>} Value)

Hope this help you. Regards.-

Sum with condition in expression of the bar chart.

Tue, 08 May 2012 19:14:01 GMT

great. you went too fast

Thanks very much !!