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: 
Not applicable

Set Expression Clarification

How's everyone doing?

Can someone help me clarify the difference between the following set expression? The goal is to return last 7 days [DaySeqNum] between max([DaySeqNum]-7 and max(DaySeqNum)

[DaySeqNum]= {">$(=max([DaySeqNum])-7)<=$(=max([DaySeqNum]))" }

Correct Result (20110125 to 20110131 assuming max([DaySeqNum])=20110131)

[DaySeqNum]= {">=$(=max([DaySeqNum])-7)<=$(=max([DaySeqNum]))" }

Incorrect Result (20110124 to 20110131 assuming max([DaySeqNum])=20110131)

The only different is >= versus > right after the first quote. Why wouldn't >= work? Shouldn't it return [DaySeqNum]-7?

If there are qvw examples of set expressions filtering on date ranges, please forward them if possible.

Your help is much appreciated!

2 Replies
Not applicable
Author

Please ignore. Forgive my posting. Cheers.

Not applicable
Author

Issue clarified =D