topic Set analysis when Field >= other Field in QlikView

Set analysis when Field >= other Field

Thu, 30 Jun 2011 14:43:31 GMT

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

Set analysis when Field >= other Field

swuehl — Thu, 30 Jun 2011 15:28:46 GMT

Hi Liesbeth

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

Have you tried

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

Regards,

Stefan

Set analysis when Field >= other Field

erichshiino — Thu, 30 Jun 2011 15:41:46 GMT

Hi,

I believe it's more like indirect set analysis:

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

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

Hope this helps,

Erich

Re: Set analysis when Field >= other Field

swuehl — Thu, 30 Jun 2011 16:25:56 GMT

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