Using set analysis to get a value of previous period

[a2ztests]

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 the table, according the field YearQuarterKey

I tried:

=max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score)

It did not work

Thanks

[agigliotti]

Hi @a2ztests ,

Maybe this:

=sum( {< YearQuarterKey = {"$(=Max(YearQuarterKey)-1)"} >} account_score)

I hope it can helps.

Best Regards

[a2ztests]

Thanks,

I want to show for every row! in the table the previous score so i think comparing it to  

$(=Max(YearQuarterKey)-1)

Will not do what i want.

Any other thoughts?

Thanks again

[agigliotti]

You can try using Above( Sum(account_score) )  if your table is sorted by YearQuarterKey field.
That expression give you the Sum(account_score) of the previous table row.

Best Regards

[whiteymcaces]

https://community.qlik.com/t5/App-Development/Using-set-analysis-to-get-a-value-of-previous-period/t...