topic Re: Button Action to Select last 3 Full Months in QlikView

Button Action to Select last 3 Full Months

prees959 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In my load script I am creating these variables :

vLast3MonthStartDate=Monthstart(today(),-4);

vLastMonthEndDate=MonthEnd(Today(),-1);

I have a date field in my data called [Date]

I am trying to select the last 3 full months of data using this action on a button click :

= '>=' & $(vLast3MonthStartDate) & '<=' & $(vLastMonthEndDate)

But it doesn't seem to select anything.

I am clearing Date as the first action

Can anyone help?

Thanks,

Phil

Anil_Babu_Samineni — Fri, 06 Jul 2018 03:46:14 GMT

Try this?

= '>=' & vLast3MonthStartDate & '<=' & vLastMonthEndDate

= '>=' & $(=vLast3MonthStartDate) & '<=' & $(=vLastMonthEndDate)

qlikviewwizard — Fri, 06 Jul 2018 04:44:17 GMT

Hi Try like this:

SUM({< DATE={"$(='>=' & $(vLast3MonthStartDate)& '<=' & $(vLastMonthEndDate))"}>}SALES)

sushil353 — Fri, 06 Jul 2018 04:49:31 GMT

hi,

Check your date field format and your variable format. you can change the format using date function..

vLast3MonthStartDate=Date(Monthstart(today(),-4));

vLastMonthEndDate=Date(MonthEnd(Today(),-1));