topic Last three months selection in QlikView

Last three months selection

prasadreddy — Tue, 13 Aug 2013 10:07:59 GMT

Hi Team,

Can any one help me

'By default i want to select last three months from month field'

Thanks in advance

Re: Last three months selection

Siva_Sankar — Tue, 13 Aug 2013 10:28:24 GMT

Try in any document with a listbox. Select three values from month listbox, and click on "Lock" in the toolbar. Do as many selections as you want: the value locked will never change, and will not be cleared. This usually is marked in blue, as selections are in green. regards. siva

Re: Last three months selection

Tue, 13 Aug 2013 10:33:56 GMT

You want it to be selected by default when any user enters the document or are you talking about one specific graph?

Re: Last three months selection

Tue, 13 Aug 2013 10:36:26 GMT

sum({<date={">=$(=Addmonths(makedate(max(year),max(month)),-3))"},month=, year=>}sales)

Re: Last three months selection

tresB — Tue, 13 Aug 2013 11:05:05 GMT

PFA