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)