topic Display Selection in a Title (ex: Jan - Nov) in QlikView

Display Selection in a Title (ex: Jan - Nov)

Wed, 17 Nov 2010 21:21:53 GMT

I have a calendar selector on the screen showing Jan, Feb, Mar and so on. If the user highlights multiple months such as Jan - Nov I would like the graph title to say something like "Selections for Jan - Nov"

If they don't choose sequential months it would be nice to just list all the months. This isnt necessary though, just nice.

Thanks!

Display Selection in a Title (ex: Jan - Nov)

johnw — Wed, 17 Nov 2010 21:28:12 GMT

Maybe this?

='Selections for ' & if(max(Month)-min(Month)+1=getselectedcount(Month),min(Month) & ' - ' & max(Month),getfieldselections(Month))

Display Selection in a Title (ex: Jan - Nov)

Wed, 17 Nov 2010 22:02:01 GMT

Hey John works great i just have one weird case. It shows "7 - 10" if i have Jul through Oct selected. I would like it to show "Jul - Oct". I tried changing the section of your code to this:

month(min(Month) & ' - ' & month(max(Month))

For some reason it then displays "Jan - Jan " with the same selection. If i get rid of the month() function it works fine with number ("7-10") but I cant seem to get it to display "Jul - Oct". I tried Date(max(month),'MMM') as well but it has the same effects as month().

Thanks

Display Selection in a Title (ex: Jan - Nov)

johnw — Wed, 17 Nov 2010 22:14:14 GMT

Huh. I'm sure I'm missing something obvious, and that this isn't the right solution, but you can probably force it to work like this:

month(makedate(2010,min(Month))) & ' - ' & month(makedate(2010,max(Month)))

Display Selection in a Title (ex: Jan - Nov)

Wed, 17 Nov 2010 22:23:47 GMT

Yep that works fine. Thanks John!