Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Title - Current Selections

Hello all -

I'd like to make my chart title reflect the current selections across two variables (which I have named SubSegment and SubAgency in my dataset).  Ideally, the chart title would read:

"SubAgency - SubSegment, $M"

If there is no SubAgency or SubSegment selected, I'd like it to still output whatever IS selected, and if there are multiple selections, I'd like it to default to "Multiple Selections, $M".  Finally, if nothing is selected (I.E I'm just looking at the total sum of my data), I'd like to display, "Total Market, $M"

Any ideas?  Thanks!

13 Replies
Not applicable
Author

If I don't select anything, I get: " - ,$M"

For now, ok.

One SubSegment/SubAgency selected: " - IT Operations, $M" / "USDA - , $M"

For now, ok.

One SubAgency and SubSegment selected: "USDA - IT Operations, $M"

Perfect.

Multiple SubAgencies and/or SubSegments selected: " - ,$M"

This needs to be fixed.

maxgro
MVP
MVP

you have to play with

- getpossible and getselected

and also with 

- or / and

swuehl
MVP
MVP

Your expressions works for me. Could you post a small sample qvw that demonstrates your issue?

Not applicable
Author

Bah - just figured it out.  SubAgency/SubSegment were the wrong variables to reference in the IF statement - I had to reference the hierarchical values that were driving the List Box/Chart.  Thank you for all your help!