Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable not working as expected in Set

Hi All,

I am trying to use the following function:

sum({<weekago={'>52<$(52+$(NumOfWeeks))'}, MONTH_DESC>}CURRENT_SALES)

I want to sum the sales of for weeks in previous year to date time period.

The NumOfWeeks variable is defined as

max({$<YEARAGO={'<1'}, MONTH_DESC>} WEEKAGO)

0 Replies