Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sravan_v007
Contributor III
Contributor III

'Allways one selected value' on 3 selected values

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..

2 Replies
tresesco
MVP
MVP

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
Contributor III
Contributor III
Author

Thanks Tres...

it worked...

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

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