Set analysis when Field >= other Field

[#1]

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

[swuehl]

Hi Liesbeth

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

Have you tried

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

Regards,

Stefan

[erichshiino · Accepted solution]

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]

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