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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis variable Year Week

  hi i would like to perform a point in time report.

i am currently trying to point back to the previous year and week based upon my selection.

my selection in this case is 201531 so i would like to return the values for 201431.

please see my attempt below

sum(<{[Year Week] = {$(=(Only(Year)-1)) & $(=Only(Week))}>}

Sales)

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try sum(<{[Year Week] = {$(=(Only(Year)-1)),$(=Only(Week))}>} Sales)


talk is cheap, supply exceeds demand