Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

As below.

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

or

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