
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if you have year and quarter field in every row then showing previous quarter value for every row w.r.t dimension quarter year is not possible with Set analysis. You have to use above() or move the calculation in back end.
FYI. Set analysis evaluate value at table not at row level. that's why it is difficult.
Regards,
Prashant Sangle
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
