Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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