"Greater than" in set analysis not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have this problem with a expression where it doesn't work when I'm using "Greater than" calculation.

But when I'm only using "Equal to" it works perfectly.

So when using below it works without problems:

SUM({< BOOKING_DATE = {'22-06-2017'} >} Sales)

But when I'm using below it doesn't work:

SUM({< {< BOOKING_DATE = {">=$('15-05-2017')"} >} Sales)

When I'm doing the same thing with another date variable, INSERT_DATE, it works perfectly. So can it be something with the setup of the BOOKING_DATE?

However, if I make the BOOKING_DATE as a Listbox and I choose the dates directly it works. So I guess the date i configured correctly?

I hope someone can help me.

Stefan

Re: "Greater than" in set analysis not working

MK_QSL — Mon, 26 Jun 2017 08:58:12 GMT

use

SUM({<BOOKING_DATE = {'>=15-05-2017'}>}Sales)

Here I am assuming that BOOKING_DATE is in DD-MM-YYYY format

Re: "Greater than" in set analysis not working

Anonymous — Mon, 26 Jun 2017 09:15:44 GMT

So simpel, and yet so useful!

Thanks a lot Manish.

Stefan

topic Re: "Greater than" in set analysis not working in QlikView

"Greater than" in set analysis not working

Re: "Greater than" in set analysis not working

Re: "Greater than" in set analysis not working