topic Re: Using Set Expressions to limit Expression values in QlikView

Using Set Expressions to limit Expression values

Anonymous — Mon, 07 May 2018 21:26:37 GMT

I have a bar chart, and I want to limit it to a 4-month sliding window, current month and three previous months. I have assembled the following set expression via suggestions on here, but it does not filter at all.

Count ({1<date = {">=$(=MonthStart(AddMonths(Today()-3)))<=$(=MonthEnd(Today()))"}>} ticket_type)

My data essentially looks like this:

ID	Month-Year	date	ticket_type

I am trying to accomplish something similar to this:

Re: Using Set Expressions to limit Expression values

maxgro — Mon, 07 May 2018 21:37:03 GMT

maybe a missing comma in the AddMonths function

Count ({1<date = {">=$(=MonthStart(AddMonths(Today(),-3)))<=$(=MonthEnd(Today()))"}>} ticket_type)

Re: Using Set Expressions to limit Expression values

Anonymous — Mon, 07 May 2018 22:01:06 GMT

Well, not that ... lol now it is completely blank. so I apparently have done something wrong

Re: Using Set Expressions to limit Expression values

Anonymous — Thu, 13 Sep 2018 21:27:09 GMT

I have finally gotten this to work.

I used

Count({<[Month-Year] = {">=$(v3MonthsAgo)"}>}JOB_ID)

where

v3MonthsAgo

is defined as

LET v3MonthsAgo = MonthStart(AddMonths(Today(),-3));