topic Re: how to get last 6 months data in QlikView

how to get last 6 months data

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

Hello!

There is a table having 2 field one is sales field and another is date field. date field contain dates of 2011 and 2012 .

Maximum date is 16/02/2012 (dd/mm/yyyy). 2012 Feb is maximum.

The requirement is display sum of sales of last 6 month in a bar chart . It will show Feb,Jan,Dec,Nov,Oct and Sept months sum(sales).

Please help me to write a set analysis for this.

Thanks in advance.

Anil_Babu_Samineni — Thu, 07 Dec 2017 17:33:46 GMT

vikasdesai — Fri, 08 Dec 2017 09:12:38 GMT

Hello ,

Use following expression to display sum of sales of last 6 month

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -5))<=$(=Date(Max(Date)))’}>} Sales )

Regards,

Vikas

Anonymous — Fri, 08 Dec 2017 09:26:09 GMT

Hi,

You can use a set analysis expression to select the Date values of the last six months:

count({<Date={'>$(=AddMonths(Max(Date),-6))'}>} sales)

Thanks,

debsahoo — Fri, 08 Dec 2017 10:35:19 GMT

I tried it but that red line shows and not working.

vikasdesai — Fri, 08 Dec 2017 11:08:05 GMT

Use following Expression

Sum({<Year=, Quarter=, Month=, Week=,Date={">=$(=MonthStart(Max(Date),-5)<=$(=Date(Max(Date)))"}>}Sales)