Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
masalepp
New Contributor

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
Highlighted

Re: Set analysis greater or egual to..?

Try this

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

Highlighted
Partner
Partner

Re: Set analysis greater or egual to..?

ITry like this:

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