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

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

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


talk is cheap, supply exceeds demand