topic Re: Display Last Three Months in QlikView

Display Last Three Months

Anonymous — Tue, 02 Jun 2015 16:04:09 GMT

I have a field called DispLD, which represents the Load Date for file data.

I want to be able to show just the last 3 months based on this field. I have made an equation below in set analysis, which works, but is only showing the DispLD - 2. It is currently april, so the expression below shows results for February ONLY. I want to be able to show results for February, March and April.

DispLD = {'$(=Max(DispLD-2))'

DispLD is formatted as YYYYMM (i.e 201504 is April 2015)

Any help you can offer is appreciated.

Re: Display Last Three Months

pokassov — Tue, 02 Jun 2015 16:20:00 GMT

DispLD = {'>=$(=Max(DispLD-2))'

Re: Display Last Three Months

Anonymous — Tue, 02 Jun 2015 16:24:38 GMT

Worked perfectly. Thank you for the quick response.

Re: Display Last Three Months

maxgro — Tue, 02 Jun 2015 16:44:52 GMT

in a chart with DispLD as dimension

try expression

concat({$ <DispLD ={">=$(=date(addmonths(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),-2),'YYYYMM'))<=$(=date(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),'YYYYMM'))"}>} distinct DispLD , ' ')

Re: Display Last Three Months

pratap6699 — Wed, 03 Jun 2015 04:01:54 GMT

DispLD = {'=date(=Max(DispLD-2),YYYYMM)'}