topic Re: last 6months sales in Connectivity & Data Prep

last 6months sales

yugesh0604 — Mon, 28 Nov 2022 07:32:31 GMT

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 — Mon, 28 Nov 2022 09:53:21 GMT

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,

yugesh0604 — Tue, 29 Nov 2022 04:30:35 GMT

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

Saurabh_K14999 — Tue, 29 Nov 2022 06:50:43 GMT

Yes

yugesh0604 — Tue, 29 Nov 2022 09:47:22 GMT

Thank you so much Saurabh...