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

Using set analysis to get a value of previous period

achin — Mon, 09 Oct 2023 11:53:06 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 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

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

agigliotti — Mon, 09 Oct 2023 13:15:49 GMT

Hi @achin ,

Could you post a sample app with mock data?

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

Cascader — Mon, 09 Oct 2023 13:33:40 GMT

this might work:

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

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

anat — Mon, 09 Oct 2023 13:30:58 GMT

give a try using below link:

https://community.qlik.com/t5/New-to-Qlik-Sense/Current-vs-Previous-Quarter/td-p/1566945