topic Filter on Date in QlikView

Filter on Date

qlikviewaf — Wed, 18 Jul 2018 12:35:31 GMT

Hi Guys,

i have a date DD/MM/YYYY field - i would like to reload the table taking just the value of the previous 12 month.

How this can be done?

For example if i run it today i would get the data from 01/08/2017 till Today.

Thank you

Re: Filter on Date

felipedl — Wed, 18 Jul 2018 12:42:55 GMT

Hi Antonio,

Do the following (assuming the date field is a numeric date interpretation)

// this will get the 01/08/2017 based of today's date.
let vDate = Num(AddYears(MonthStart(Today()),-1));

Load *
From [Whatever]
where [Date Field]>=$(vDate);

Felipe.

Re: Filter on Date

qlikviewaf — Wed, 18 Jul 2018 13:02:45 GMT

the result is 01/07/2018 instead of 01/08/2018

let vPrevious12Month = Num(AddYears(MonthStart(Today()),-1));

Re: Filter on Date

felipedl — Wed, 18 Jul 2018 14:16:12 GMT

Use AddMonths instead, like this:

let vDate = Num(AddMonths(MonthStart(Today()),-11));

Re: Filter on Date

vishus913 — Wed, 18 Jul 2018 14:20:05 GMT

hi yes,

Felip is right

add months would do the job

Re: Filter on Date

felipedl — Wed, 18 Jul 2018 14:34:26 GMT

Glad it helped .