topic Re: help regarding selections in QlikView

help regarding selections

shree909 — Mon, 26 Nov 2012 23:03:47 GMT

Hi iam attaching a file

which conists for months from Jan to dec

this selection i want to implement at the label level

when i select jan, apr manually it shows correct(Jan-Mar)

but when i split the months into quarters it doesnt show properly.it shows as (ja-ar)

please find the file as attached

shree909 — Tue, 27 Nov 2012 17:05:25 GMT

hi please find the attachment

MayilVahanan — Tue, 27 Nov 2012 17:13:07 GMT

PFA

shree909 — Tue, 27 Nov 2012 17:16:47 GMT

it works fine for q1 and q2 ,

but when i select manually jan, apr ,jun it has show as

jan-apr but it shows as differnt .

can u rectify it

Gysbert_Wassenaar — Tue, 27 Nov 2012 17:26:41 GMT

Try:

=if((GetSelectedCount(Month)>1)and(GetSelectedCount(Month)<12),

(left(replace(GetFieldSelections(Month,'',12),'(',''),3)&'-'&right(replace(GetFieldSelections(Month,'',12),')',''),3)),

GetFieldSelections(Month))

MayilVahanan — Tue, 27 Nov 2012 17:31:52 GMT

PFA

Let me know, this is your requirement