Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
b1onny
Contributor
Contributor

Using set analysis to get a value of previous period

Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-quarter combination). I want to use set analysis in a table presentation on my app, and to add the field previous_quarter_score to every row ! in the table, according the field YearQuarterKey I tried: =max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score) It did not work. Any thoughts on how to accomplish this? Thanks

Labels (1)
1 Reply
IamAlbinAntony
Creator
Creator

Try Above function;

IamAlbinAntony_0-1696075830467.png