topic Re: Need a button to select last 3 months in QlikView

Need a button to select last 3 months

Anonymous — Fri, 20 Mar 2015 14:51:37 GMT

How to create a button - when I click the button it should select last 3 months data.

Re: Need a button to select last 3 months

mrossoit — Fri, 20 Mar 2015 15:14:41 GMT

I suggest you to define a field in the same table of your date field as first day of the month:

MakeDate(my_year, my_month, 1) as YYYYMM01

MakeDate(year(my_date), month(my_date), 1) as YYYYMM01

Then define in variables view a variable that lists the last 3 months in date format:

varLast3Months = '(' &date(AddMonths(monthstart(today()),-3)) & '|' & date(AddMonths(monthstart(today()),-2)) & '|' & date(AddMonths(monthstart(today()),-1)) & ')'

Finally create your button with an action on selection in the field indicating your new data field (YYYYMM01) as field and =varLast3Months as search string.

Hope it helps.

Max

Re: Need a button to select last 3 months

terezagr — Fri, 20 Mar 2015 15:22:33 GMT

Check this out: Dynamically Selecting Timeframes

Re: Need a button to select last 3 months

Anonymous — Mon, 23 Mar 2015 13:18:40 GMT

Hi Rosso, Terrific result. It is working perfectly...

Re: Need a button to select last 3 months

Anonymous — Mon, 23 Mar 2015 13:21:29 GMT

Need a small favour. The below is to bring up the 1st date of month. How to change this to bring up for weeks?

MakeDate(year(my_date), month(my_date), 1) as YYYYMM01

Re: Need a button to select last 3 months

mrossoit — Mon, 23 Mar 2015 13:38:00 GMT

I'm not sure to understand what result you want to reach. Could LunarweekStart() function help you in doining it?

Do you want to list all weeks of your month or, starting from my_date, you need to find the date when that week starts?

Re: Need a button to select last 3 months

Anonymous — Mon, 23 Mar 2015 14:03:39 GMT

I figured the solution... Thanks for your prompt reply.

Re: Need a button to select last 3 months

leandroserrado — Thu, 02 Jun 2016 20:03:10 GMT

Great...

Re: Need a button to select last 3 months

pgalvezt — Mon, 15 May 2017 20:34:49 GMT

Hi, Viyay I need the last Week too, Could you pls put your solution.

Appreciate that,

Thanks!