Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
desauv86
Contributor

"Greater than" in set analysis not working

Hi

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

1 Solution

Accepted Solutions
MVP
MVP

Re: "Greater than" in set analysis not working

use

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

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

View solution in original post

2 Replies
MVP
MVP

Re: "Greater than" in set analysis not working

use

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

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

View solution in original post

desauv86
Contributor

Re: "Greater than" in set analysis not working

So simpel, and yet so useful!

Thanks a lot Manish.

Stefan