topic Re: How to show last 3 months sales for maximum date of the month in QlikView

How to show last 3 months sales for maximum date of the month

rkpatelqlikview — Tue, 09 Oct 2018 00:36:51 GMT

Dear Qlik,

Please suggest on this.

Here i have months and trend analysis in Bar chart

Dimension-> Month,

Expression - >

round(count({<Date={"$(=max(Date))"},[Difference Category]={'7Days'}>} DISTINCT Items)/

Count(DISTINCT{<Date={"$(=max(Date))"}>} Items *100,0.01,0).

I can able to see only recent month bar.

Please find the below screen shot for your reference.

i should see the sep and aug months with calculation of the maximum date of that particular month. Please advice how to overcome this,

Thanks in Advance.

Sergey_Shuklin — Tue, 09 Oct 2018 05:30:07 GMT

Hello!

Improve your set condition with Addmonths function:

Date={">$(=monthstart(Addmonths(max(Date),-2)))"} if your month field ends with the last day of month.

rkpatelqlikview — Tue, 09 Oct 2018 08:30:58 GMT

Thanks Sergey,

Thanks for your response.

I tried with this one but values are not correct. It taking entire month data not max date of the month.

Please find the below screen shot and attached QVW as well.

Thanks in advance.

Sergey_Shuklin — Tue, 09 Oct 2018 10:53:25 GMT

Now I see the point. So, there are many ways how to get max day of the month, but I prefer to add one more column as flag of max day.

And then use a simple set analysis condition: end_month = {1}

hope this way will be suitable for you

rkpatelqlikview — Tue, 09 Oct 2018 11:36:23 GMT

Thanks for your great help.

It's working good. Thanks once again.