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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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!