Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis for time range dependent on selection

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

2 Replies
felcar2013
Partner - Creator III
Partner - Creator III

maybe you can try

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

Anonymous
Not applicable
Author

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