topic Select last 31 days with action button in QlikView

Select last 31 days with action button

pepe2209 — Mon, 13 Jan 2014 14:18:25 GMT

Hello,

I thought this would be easy but I can't get it to work:

I have the variable 'Startdate' and with one click on an action button i want to select only the dates within the last 31 days.

I tried the action select in field with field 'Startdate' and value: =if(Startdate>=today()-31, '*')

but this does not work.

The only other way i can think of is creating a new field in the script 'Lastmonth' with 1 for each 'Startdate' within the last month. But i rather not add another variable to an already large dataset and application.

is it possible to do this without a extra field?

your help would be much appreciated.

Regards

Peter

Re: Select last 31 days with action button

Nicole-Smith — Mon, 13 Jan 2014 14:27:23 GMT

Select in Field: Startdate with the expression:

='>=' & date(today()-31) & '<=' & today()

Re: Select last 31 days with action button

Michiel_QV_Fan — Mon, 13 Jan 2014 14:29:16 GMT

Peter,

Do you need the last 31 days prior to the selected date, or, do you need the current month or do you need the previous month?

Re: Select last 31 days with action button

pepe2209 — Mon, 13 Jan 2014 14:43:14 GMT

@Nicole Thanks this works!

Re: Select last 31 days with action button

pepe2209 — Mon, 13 Jan 2014 14:44:47 GMT

Hello

I actually want both, the last 31 days prior to today, and the previous month. The first one is already fixed thanks to Nicole. Now I'm trying to figure out the second one

Re: Select last 31 days with action button

pepe2209 — Mon, 13 Jan 2014 14:48:04 GMT

Ok now I use this:

='>=' & MonthStart(today(),-1) & '<=' & MonthEnd(today(),-1)

for selecting all dates in the previous month