topic Re: Display Last Three Months in QlikView

Display Last Three Months

Anonymous — Thu, 07 May 2015 14:18:32 GMT

The current equation below works to display max load date:

LOAD_DATE = {"$(=Date(Max(LOAD_DATE), 'YYYY/M'))"}

However, I would like the chart to display last 3 months. I tried below but this did not work.

LOAD_DATE = {"$(=Date(Max(LOAD_DATE) - 2, 'YYYY/M'))"}

Any suggestions?

Thank you,

- dave

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 14:29:37 GMT

Try this:

LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 14:46:07 GMT

Sunindia - This helps, but I need the previous months to stay displayed even when the user picks a specific month.

For example, I have month options at the top of the application: Jan, Feb, Mar

When user clicks Mar, I want them to be able to see Mar, and the two previous months.

Hope this makes sense

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 14:47:49 GMT

What is the name of the dimension you are using for Month?

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 14:49:29 GMT

BL_Month

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 14:50:58 GMT

See if this helps:

Try this:

{<LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}, BL_Month = >}

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 14:56:57 GMT

That did not seem to work. No data was displayed. Whole expression is below.

count({<

Field1={'Value1'},

Field2= {'Value2'},

LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}>}

Line_ID)

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 15:00:47 GMT

Would you be able to share a sample?

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 15:02:49 GMT

Unfortunately I cannot. But thank you for your help this far

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 15:10:19 GMT

So when you use this expression:

Count({<Field1={'Value1'}, Field2= {'Value2'}, LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}, BL_Month = >} Line_ID)

you see no results?

but this works?

Count({<Field1={'Value1'}, Field2= {'Value2'}, LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}>} Line_ID)

Is this what is happening?

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 15:12:51 GMT

Correct. With the BL_Month=> part of the expression I am seeing no data.

I think I may have found a solution. I add a '1' after the count syntax.

Count({1<Field1={'Value1'}, Field2= {'Value2'}, LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}>} Line_ID)

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 15:15:49 GMT

If you add 1 then your expression won't change on any selection. If that is acceptable then 1 will work out

Best,

Sunny

Re: Display Last Three Months

Anonymous — Thu, 07 May 2015 15:18:14 GMT

Thats fine. I believe the chart will still show the previous 3 months regardless of selection which is the desired effect.

Thank you very much for your help!

Re: Display Last Three Months

sunny_talwar — Thu, 07 May 2015 15:19:36 GMT

Yup no problem. I am glad it worked out.