Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

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

Set Analysis Exclusions

Hi all,

I have a case where my dimension is [Month], and my measure is [Sales]. With my expression, I need to track [Sales] according to user's Month selection. For instance, if the user selects 4/2014 and 5/2014, I need to display the sum of [Sales] that happened "before" 4/2014. Right now, I'm using the following:

Sum({$<[Month]= E({<[Month]={"='$(Min([Month]))'"}>})>} [Sales])

But I'm simply getting the whole sum of [Sales] all across my app. Does anyone have some insight into this?

Thanks

Tags (1)
2 Replies
morganaaron
Valued Contributor

Re: Set Analysis Exclusions

Might have to do with the formatting of your dates - also worth considering if you simply need to see "less than the min month" you can replace the E() with '<=' and use your min statement.

Attached is an that solves the above - I loaded a new date field due to the formatting, but if that's the format you use it should work without the new date I added.

fernando_tonial
Valued Contributor

Re: Set Analysis Exclusions

Hello,

Try this expression:

Sum({$<[Month]={"<$(=Min([Month]))"}>} [Sales])

Maybe, you need ignore the field.

Sum({$<[MonthName]=, [Month]={"<$(=Min([Month]))"}>} [Sales])

Best Regards.

Tonial.

Community Browser