topic Set analysis for time range dependent on selection in QlikView

Set analysis for time range dependent on selection

Anonymous — Mon, 04 Feb 2013 08:50:10 GMT

Hello!

I have a table with IDs and associated times and values. Now I want to show in a table diagramm the maximum value of all entries, which are in a time certain time range around the selection.

I imagined something like this, which doesn't seem to be correct, yet.

max({$<ID = , Time <= AddMonths(max(Time), 1)>} Value)

also tried

max({$<ID = , Time <= $(=AddMonths(max(Time), 1))>} Value)

but to no avail. Am I on the right track?

Regards,

Sandro

Re: Set analysis for time range dependent on selection

felcar2013 — Mon, 04 Feb 2013 09:34:42 GMT

maybe you can try

max({$<ID = , Time={"<= $(=AddMonths(max(Time), 1))"}>} Value)

Re: Set analysis for time range dependent on selection

Anonymous — Mon, 04 Feb 2013 10:08:40 GMT

Can't make that work either. Wouldn't the expression in quotes also evaluate to a boolean? And when comparing Time to it, never get me anywhere?

Either way. Unfortunately, not yet the solution

Sandro