Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nathanfurby
Specialist
Specialist

Problem using TOTAL function in Text Pop-Up on chart

Hello All

I have a particular problem when trying to show the Total for my dimension in a stacked bar graph. I have managed to get the Total to show in the text pop-up by creating an additional expression. The problem now is that the 2nd dimension legend shows all possible values across the entire selection rather than just the possible values defined by the chart expressions. This is a problem becauseI have many possibilities in my real world application.

I'm guessing this has something to do with the TOTAL function and I have tried a number of things in the Set analysis of the 2nd Pop-Up expression with no luck. Also an issue - I have two 'Amount' columns.

Please take a look at the sample app attached. In short, I want to see the total across the 2nd Dimension (Strategy) but without all Strategies showing in the Legend of the SUM(Amount2) chart.

Many thanks

N

1 Reply
nathanfurby
Specialist
Specialist
Author

Any wise QV experts out there with some direction?