Skip to main content
Announcements
Qlik Insider: Product Roadmap Edition on Feb 26, 1 PM ET: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jaksaendo
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
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
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 🙂