Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Set Analysis

Hi, I am trying to sum visit counts but only if the visit_date is greater than year 2011, this expression isn't working:

Sum({<date(visit_date) >= {year(2011))}> } visit_count)

3 Replies
Michael_Tarallo
Not applicable

Re: Set Analysis

Hi Monica - you need to use what we call $(dollar) expansion - it enables the Set Analysis function to use another function in the comparison.

I can work out a sample for you - but in the mean-time -I discuss this in part 2 of this Set Analysis Introduction as well:

Part 1: A Beginners' Introduction to Set Analysis (video)

Part 2: Set Analysis - Part 2 - Cool Stuff You Can Do (video)‌ at the 11:45 mark

Let me see if I can quickly get you a sample.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Not applicable

Re: Set Analysis

BTW - here is an example in the community

Set analysis sum between two given dates

Please note that you can only use field names on the left of the equal sign in a set expression, no functions.

Let me know how you do

Regards,
Mike Tarallo
Qlik
sunny_talwar
Not applicable

Re: Set Analysis

May be create a field in the script like this

Year(visit_date) as Year


and then like this

Sum({<Year ={'>=2011'}>} visit_count)