topic Re: Selection month in QlikView

Selection month

Mon, 20 Apr 2015 14:47:33 GMT

Hello

My problem "is simple" to a list box of months I want to know which have been selected and if within that selection this one in particular.

Ex:

Select January, March, July, September, October, November and December, how I can know if this March, I selected?

I've tried all kinds of functions and it is impossible there is always some event that meets my condition.

Thanks for your help

Re: Selection month

awhitfield — Mon, 20 Apr 2015 14:50:40 GMT

Hi Antonio,

you need a field for 'Year' too!

Andy

Re: Selection month

Mon, 20 Apr 2015 14:54:24 GMT

No need to know if this March within selected or is not.

Re: Selection month

awhitfield — Mon, 20 Apr 2015 14:58:28 GMT

If it's selected, it will show Green!

Andy

Re: Selection month

Mon, 20 Apr 2015 15:05:27 GMT

Yes, I know.

But I want a variable for compare with other.

Re: Selection month

Anonymous — Mon, 20 Apr 2015 15:08:48 GMT

every month in green color are selected,if you want to be sure you can do a test , creating a simple table with fields you need,once you confirmed your info delete the table.

Regards

Re: Selection month

awhitfield — Mon, 20 Apr 2015 15:11:37 GMT

Sorry Antonio, but I really don't understanding what you are asking for! Can you expand / clarify your requirements?

Regards

Andy

Re: Selection month

Mon, 20 Apr 2015 15:11:58 GMT

I need something like

Index(text(getfieldselections ( Mes, ', ')),'mar')

Re: Selection month

Mon, 20 Apr 2015 16:02:30 GMT

Hi Antonio, try this:

=substringcount(concat(DISTINCT Mes),'mar')

If count =1 March is selected...

I hope you serve!

Re: Selection month

Mon, 20 Apr 2015 16:31:56 GMT

Thanks so much, worked perfectly