topic Set expression compare in QlikView

Set expression compare

stabben23 — Thu, 06 Dec 2012 10:52:12 GMT

Hi, Here is my problem:

Selected Year 2011.

I have a customer with no sale in Dec 2011, YTD LY (2010) will only show me sale to Nov, ihave sale in dec 2010.

My expression for YTD LY says <=max(Month) but in this case max month will be Nov.

sum({$<Year = {$(=only(Year)-1)}, Month = {"<=$(=max(Month))"}>}Invoiced)

Qlikview gives me the "correct" values based on the expression, but how should i solve this issue?

The report is dynamic so when i choose for ex okt, okt 2010 will be higlighted in YTD LY.

sum({$<Year = {$(=only(Year)-1)}, Month = {"<=$(=max({1} Month))"}>}Invoiced)

will give me the correct value, but will be static and show me sale Jan-Dec no matter what.

Gysbert_Wassenaar — Thu, 06 Dec 2012 11:45:03 GMT

Is this what you need?

sum({$<Year = {$(=only(Year)-1)}, Month = {"<=$(=max({$<Year = {$(=only(Year)-1)}>} Month))"}>}Invoiced)

stabben23 — Thu, 06 Dec 2012 12:17:27 GMT

Thank Gysbert,

I will remember set expression like this in future

Works as I wanted.