topic Re: Get Months string from NOT selection in QlikView

Get Months string from NOT selection

Mon, 15 Sep 2014 06:20:59 GMT

Hi all,

Please help me with some issue:

I want to get some string that contains the opposite months from my selection in case there is NOT on the selection:

For example: I selected the months Mar, Apr, May, Jun, Jul, Aug, Sep and Dec - I'll see in the Current Selection Box:

"NOT Jan, Feb, Nov"

I want to do some manipulation to get the string: "Mar, Apr, May, Jun, Jul, Aug, Sep, Dec"

Put my example on the attachment...

Thanks!

ajaykumar1 — Mon, 15 Sep 2014 06:28:24 GMT

Hi,

Take one listbox and in the expression ='Not' & Monthname

Just try.

Regards,

Ajay

tresB — Mon, 15 Sep 2014 06:32:53 GMT

In a list box:

='Not Selected Months are : ' &Concat(Distinct {<Month=e(Month)>} Month, ' ,')

anbu1984 — Mon, 15 Sep 2014 06:33:53 GMT

Concat(Month,',')

Mon, 15 Sep 2014 06:35:16 GMT

I did the same but instead e(Month) put p(Month) to get my selected months. Thanks!