topic Re: 'Allways one selected value' on 3 selected values in QlikView

'Allways one selected value' on 3 selected values

sravan_v007 — Tue, 13 Aug 2013 10:06:35 GMT

Hi All,

I have a problem.

I Have a moth feeld and i want to use 'Allways one selected value' on 3 selected values...

i.e

another thing is I have 8 months of data for now, so when ever new month will add, It should select last 3 months only.

i.e "Jan, Feb, Mar, Apr, May, Jun, Jul, Aug" in this I allways want "Jun, Jul, Aug" should selected

and

when ever "Sep" will add it should select "Jul, Aug, Sep".

if it's possible please help...

Thanks in advance..

tresB — Tue, 13 Aug 2013 10:54:22 GMT

for your desired action(preferrably,Trigger->OnOpen(doc)) , you can write the string expression something like this:

='('&Month(Max(Date))&'|'&Month(Max(Addmonths(Date,-1)))&'|'&Month(Max(Addmonths(Date,-2)))&')'

where, Date is your Date field

Update: PFA

sravan_v007 — Tue, 13 Aug 2013 12:16:32 GMT

Thanks Tres...

it worked...

I just modified for my reqirement.......

='(' & DATE#(max(Month)-2,'YYYYMM') & '|' & DATE#(max(Month)-1,'YYYYMM') & '|' &DATE#(max(Month),'YYYYMM') & ')'