Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Sum with condition in expression of the bar chart.

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.

ITEMValue
ACT100
ACT20
ACT40
AOP110
AOP21
AOP30


Tks Regards

1 Solution

Accepted Solutions
Not applicable

Sum with condition in expression of the bar chart.

Your expression must be:

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

Hope this help you. Regards.-

View solution in original post

2 Replies
Not applicable

Sum with condition in expression of the bar chart.

Your expression must be:

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

Hope this help you. Regards.-

View solution in original post

Not applicable

Sum with condition in expression of the bar chart.

great. you went too fast

Thanks very much !!