Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ariables in set analysis

Using variables in set analysis in Qlik Sense 3

Trying to plot graf limited from todays week and forward

Browsing the forum I found excellent tips that supposed to work but unfortunately they don’t

Defined the variable:

LET vWeekCurrent = Week(Today());

Formula:

Sum({$<Week={$(>vWeekCurrent)}>}([Amount 2015])

Don’t get it how to achieve greater than vWeekCurrent in the set
Data is two columns Week and Amount 2015

This works fine with

Sum({$<Week={“>27”}>}([Amount 2015])

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

may be like this

Sum({$<Week={">=$(=vWeekCurrent)"}>}([Amount 2015])

View solution in original post

2 Replies
arulsettu
Master III
Master III

may be like this

Sum({$<Week={">=$(=vWeekCurrent)"}>}([Amount 2015])

Not applicable
Author

Thanks your proposal work, now.

Not sure why it did work from start