last 6months sales

[yugesh0604]

Hi Guys,

Need Suggestions from you

syntax for last 6months sales by using set analysis and Bar Chart... 

In the Qlik Community Some Syntax's available  but it will  again give total sales...

[Saurabh_K14999]

Hi,

Use the following expression to show last 6 months sales.

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

Regards,

SK

[yugesh0604]

is it same expression work in  both Set analysis and Barchart also?

[Saurabh_K14999]

Yes

[yugesh0604]

Thank you so much Saurabh...