Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis when Field >= other Field

I read and tried the case when in a Set Analysis one Field shoud be equal to another Field: sum({< OrderDate = DeliveryDate>} Sales). This works fine, but now I am looking for the correct statement when one Field >= another Field:

sum({< OrderDate >= DeliveryDate>} Sales). This doesn't work.

Have anyone an idea?

Gr. Liesbeth

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

I believe it's more like indirect set analysis:

sum (   { < A ={"=A>B"} > } C)

or

sum({< OrderDate = {"=OrderDate>=DeliveryDate"}>} Sales)

Hope this helps,

Erich

View solution in original post

3 Replies
swuehl
MVP
MVP

Hi Liesbeth

I think you need to use quotation marks to guard the >

Have you tried

sum({< OrderDate = {">=DeliveryDate"}>} Sales).

Regards,

Stefan

erichshiino
Partner - Master
Partner - Master

Hi,

I believe it's more like indirect set analysis:

sum (   { < A ={"=A>B"} > } C)

or

sum({< OrderDate = {"=OrderDate>=DeliveryDate"}>} Sales)

Hope this helps,

Erich

swuehl
MVP
MVP

Hi,

I think there was a similar discussion just days ago:

http://community.qlik.com/message/121739

Please notice the problem if there is not a 1:1 relationship between the dates (and possible solution also noted).

Hope this helps,

Stefan