topic Re: Re: Chart Title - Current Selections in QlikView

Chart Title - Current Selections

Fri, 09 May 2014 15:31:40 GMT

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!

Re: Chart Title - Current Selections

Colin-Albert — Fri, 09 May 2014 16:14:08 GMT

GetCurrentSelections() will return a list of the selected values for all fields

GetCurrentSelections(fieldname) will return a list of the selected values for one field

Re: Chart Title - Current Selections

Colin-Albert — Fri, 09 May 2014 16:16:34 GMT

GetCurrentSelections() will insert each field on a separate line, you can remove the carriage returns like this.

REPLACE(REPLACE(GetCurrentSelections(), CHR(13), ' '), CHR(10), ' ')

Re: Chart Title - Current Selections

Fri, 09 May 2014 16:34:27 GMT

Many thanks, Colin. Any idea how to deal with "Multiple Selections"? Is there a way to essentially say, "If current selections > 1, then ______"?

Re: Chart Title - Current Selections

Colin-Albert — Fri, 09 May 2014 16:41:11 GMT

Have a look at only(fieldname) this will return the field name if one selection has been made, otherwise null.

Re: Chart Title - Current Selections

Colin-Albert — Fri, 09 May 2014 16:42:35 GMT

Also GetSelectedCount(fieldname)

Re: Chart Title - Current Selections

Fri, 09 May 2014 16:59:37 GMT

So right now I've got:

=IF(GetSelectedCount(SubAgency)>1 or GetSelectedCount(SubSegment)>1,'Multiple Selections, $M',SubAgency&' - '&SubSegment&', $M')

Which is correctly labeling the graphs when I make my singular selections, but is not working when I make multiple selections. Any ideas what's wrong with my syntax/construction?

Re: Re: Chart Title - Current Selections

maxgro — Fri, 09 May 2014 17:20:53 GMT

see attachment

=IF(GetPossibleCount(SubAgency)>1 or GetPossibleCount(SubSegment)>1,'Multiple Selections, $M',

SubAgency & ' - ' & SubSegment & ', ' & num(round(sum(Expression1)/1000000),'#.##0') & ' $M')

Re: Chart Title - Current Selections

Fri, 09 May 2014 17:28:43 GMT

Massimo - the problem right now isn't getting the last part of the IF function - the Else - to work, it's getting the Condition and the Then. It's not displaying "Multiple Selections, $M" when I select more than one SubAgency or SubSegment.

Re: Chart Title - Current Selections

swuehl — Fri, 09 May 2014 17:33:43 GMT

So what it its showing? Have you tried any other text just for testing?

Note that you need active selections in these fields, just making no selection will execute the Then branch (But Massimo's solution using GetPossibleCount() should do this).

Re: Chart Title - Current Selections

Fri, 09 May 2014 17:43:12 GMT

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.

Re: Chart Title - Current Selections

maxgro — Fri, 09 May 2014 17:47:01 GMT

you have to play with

- getpossible and getselected

and also with

- or / and

Re: Chart Title - Current Selections

swuehl — Fri, 09 May 2014 17:49:01 GMT

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

Re: Chart Title - Current Selections

Fri, 09 May 2014 18:07:06 GMT

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!