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: 
Praveen11
Contributor
Contributor

Syntax for the set analysis

I'm new to Qlik So please help me.

I want to show sales data for this quarter till date in front end. I need  to write this in  set analysis.

Can someone Share  the logic for this   

Labels (1)
2 Replies
BrunPierre
Partner - Master
Partner - Master

As below.

Sum({$<SalesDate={">=$(=QuarterStart(Max(SalesDate)))<=$(=Max(SalesDate))"}>} SalesAmount)

or

Sum({$<SalesDate={">=$(=QuarterStart(Today()))<=$(=Today())"}>} SalesAmount)

brandon698sherrick
Contributor
Contributor

Hello Kynect@Praveen11 ,

Replace this with the actual date field from your dataset that represents the transaction date or timestamp. This part calculates the first day of the current quarter. Today() gives the current date, QuarterStart() finds the first day of the current quarter, and MonthStart() gets the first day of the month. ">=" & Date(...) ensures that you're selecting dates on or after the first day of the current quarter.
{}: This encloses your set analysis expression. Sum(SalesAmount): Replace SalesAmount with your actual sales measure.

Best Regards,
kyconnect gov