Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Liesbeth
I think you need to use quotation marks to guard the >
Have you tried
sum({< OrderDate = {">=DeliveryDate"}>} Sales).
Regards,
Stefan
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
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