topic Set Analysis - numeric date range doesn't work in QlikView

Set Analysis - numeric date range doesn't work

pirtekmismanage — Thu, 31 May 2018 13:42:51 GMT

Hi Guys,

I am trying to get the total sales figures for certain accounts where their status "expiry date" is lower than the currently selected month. The vCurrentMonthSelection variable is a short date format variable 'MMM YYYY' and it is only takes the selected month from an alternative calendar what I use as a listbox for filtering. Anyway it is irrelevant from the point of the question I believe.

Unluckily it does not interpret the EndDateNum criteria. It does not work either with $(=vCurrentMonthSelection) also tried single cotes no success. Any idea why not? Both side are in the same format I double checked.

SUM({<Event = {'Sales'}, GroupAccountType = {'National'}, New_Renewal={'Re-opened','New'}, EndDateNum = {"> (NUM($(vCurrentMonthSelection)))"}>} TotalExcVAT)

Thanks in advance for any reply.

Re: Set Analysis - numeric date range doesn't work

sunny_talwar — Thu, 31 May 2018 15:45:42 GMT

May be try this

Sum({<Event = {'Sales'}, GroupAccountType = {'National'}, New_Renewal={'Re-opened','New'}, EndDateNum = {">$(=Num($(vCurrentMonthSelection)))"}>} TotalExcVAT)

Re: Set Analysis - numeric date range doesn't work

shiveshsingh — Thu, 31 May 2018 15:51:07 GMT

Try this

SUM({<Event = {'Sales'}, GroupAccountType = {'National'}, New_Renewal={'Re-opened','New'}, EndDateNum =

{">$ (=NUM($(vCurrentMonthSelection)))"}>} TotalExcVAT)