topic Re: May2018-Oct 2018 restriction in bar chart in QlikView

May2018-Oct 2018 restriction in bar chart

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

Hi Experts,

Can any one please help me on below requirement.

I have a date field in DD/MM/YYYY Format which contains the data from 1999 to 2022 years dates.like

Reporting Date

01/01/1999

02/02/1999

...

....

01/01/2022

Means in the app it contains Jan 2018 to Dec 2018 data already.

But In a bar chart I have to restrict data from current month to following 5 months bars like

May 2018,June 2018,Jul 2018,Aug 2018,Sep 2018,Oct 2018

in the next month the chart has to show data from June 2018,Jul 2018,Aug 2018,Sep 2018,Oct 2018,Nov 2018.

My Measure is Sum(sales).

Please help me to include this 6months restriction expression in the above measure.

Thanks in advance.

Re: May2018-Oct 2018 restriction in bar chart

vishsaggi — Tue, 29 May 2018 14:37:43 GMT

Can you provide some sample data or qvw file to look into?

Re: May2018-Oct 2018 restriction in bar chart

shiveshsingh — Tue, 29 May 2018 15:47:12 GMT

Can you try this?

=sum({<Date = {">=$(=Date(Max(Date),'DD/MM/YYYY'))<=$(=(Addmonths(Date),-5))"}>}Sales)

Re: May2018-Oct 2018 restriction in bar chart

Anil_Babu_Samineni — Wed, 30 May 2018 02:53:44 GMT

May be this as measure?

Sum({<[Reporting Date]={">=$(=Date(MonthStart(AddMonths(Max([Reporting Date]),-5)),'DD/MM/YYYY'))<=$(=Date(MonthEnd(Max([Reporting Date]),'DD/MM/YYYY')))"}>} sales)