Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Barchart Total

I face the following Problem: I have products with plan and actual. not all products have plandata.

In  straight table I define for actual (if plandata>0, sum(actual)) and I define "sum of rows" and it's good (no totals)

In a barchart I need the totals but only for those products which had been defined a plandata.

But when I define totals, there is a total for all  products. Even if I Change my Dimension If (product <>'C',Product,null()) it doesnot work

How can I achieve that I see the total Actual only for those products which had been planned In the attached sample, the total should Show 150 for Actual but not 350!

any idea?

1 Solution

Accepted Solutions
sunny_talwar

This may be?

=if (column(1)>0,sum({<Plan = {"=Len(Trim(Plan)) > 0"}>}Act),null())

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

This may be?

=if (column(1)>0,sum({<Plan = {"=Len(Trim(Plan)) > 0"}>}Act),null())

Capture.PNG

View solution in original post

MK_QSL
MVP
MVP

Like this?