Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
you have to play with
- getpossible and getselected
and also with
- or / and
Your expressions works for me. Could you post a small sample qvw that demonstrates your issue?
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!