Discussion Board for collaboration related to QlikView App Development.
I have a problem.
I Have a moth feeld and i want to use 'Allways one selected value' on 3 selected values...
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
when ever "Sep" will add it should select "Jul, Aug, Sep".
if it's possible please help...
Thanks in advance..
for your desired action(preferrably,Trigger->OnOpen(doc)) , you can write the string expression something like this:
where, Date is your Date field
I just modified for my reqirement.......
='(' & DATE#(max(Month)-2,'YYYYMM') & '|' & DATE#(max(Month)-1,'YYYYMM') & '|' &DATE#(max(Month),'YYYYMM') & ')'