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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis greater or egual to..?

Hi, Could someone explain me why my set analysis is given me zero as an result:

sum({$<EndDate={"$(>=AddMonths(monthname(today()),-6))"}>}Volume)

My intention is to get volumes from last full six months.

Br

2 Replies
sunny_talwar

Try this

Sum({$<EndDate={"$(='>=' & AddMonths(Today(), -6))"}>}Volume)

OmarBenSalem
Partner - Champion II
Partner - Champion II

ITry like this:

sum({$<EndDate={">=$(=AddMonths(monthname(today()),-6))"}>}Volume)