Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
yugesh0604
Contributor
Contributor

last 6months sales

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...

Labels (1)
4 Replies
Saurabh_K14999
Contributor III
Contributor III

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
Contributor
Contributor
Author

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

Saurabh_K14999
Contributor III
Contributor III

Yes

yugesh0604
Contributor
Contributor
Author

Thank you so much Saurabh...