topic Re: Using set analysis to get a value of previous period in App Development

Using set analysis to get a value of previous period

a2ztests — Tue, 26 Sep 2023 13:06:37 GMT

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

Re: Using set analysis to get a value of previous period

agigliotti — Tue, 26 Sep 2023 13:51:30 GMT

Hi @a2ztests ,

Maybe this:

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

I hope it can helps.

Best Regards

Re: Using set analysis to get a value of previous period

a2ztests — Wed, 27 Sep 2023 06:03:44 GMT

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

Re: Using set analysis to get a value of previous period

agigliotti — Wed, 27 Sep 2023 08:11:24 GMT

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

Re: Using set analysis to get a value of previous period

whiteymcaces — Mon, 20 Nov 2023 12:49:29 GMT

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