Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As below.
Sum({$<SalesDate={">=$(=QuarterStart(Max(SalesDate)))<=$(=Max(SalesDate))"}>} SalesAmount)
or
Sum({$<SalesDate={">=$(=QuarterStart(Today()))<=$(=Today())"}>} SalesAmount)
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.