https://community.qlik.com/t5/App-Development/need-to-CY-vs-PY-Values-in-Line-chart/m-p/2481961#M100883 <P>i have dso and fiscper fields, creating line chart to show dso values of all fiscper and corresponding previous year fiscper values.</P> <P>DSO formula to should all fiscper values</P> <P>Avg(Aggr(avg(Aggr(distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor))</P> <P>iam using below function to get previous year DSO values</P> <P>Above(<BR />Avg({1&lt;fiscper&gt;}Aggr(avg({1&lt;fiscper&gt;}Aggr({1&lt;fiscper&gt;}distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor)),12)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="swathi5_0-1726557353014.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171753iD64D51CC8155E444/image-size/medium?v=v2&amp;px=400" role="button" title="swathi5_0-1726557353014.png" alt="swathi5_0-1726557353014.png" /></span></P> <P>&nbsp;</P> <P>previous year DSO formula is working fine where there no selection on fiscper, when selecting fiscper it is not giving correct ouptut. when i filtered 2022-01, it need to show 2021-01 value, but it giving something 2023-01 , but value showing again 2022-01. kindly help me</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="swathi5_1-1726557630414.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171754iC99A74E30F787562/image-size/medium?v=v2&amp;px=400" role="button" title="swathi5_1-1726557630414.png" alt="swathi5_1-1726557630414.png" /></span></P> <P>&nbsp;</P> Fri, 15 Nov 2024 20:52:10 GMT swathi5 2024-11-15T20:52:10Z https://community.qlik.com/t5/App-Development/need-to-CY-vs-PY-Values-in-Line-chart/m-p/2481961#M100883 <P>i have dso and fiscper fields, creating line chart to show dso values of all fiscper and corresponding previous year fiscper values.</P> <P>DSO formula to should all fiscper values</P> <P>Avg(Aggr(avg(Aggr(distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor))</P> <P>iam using below function to get previous year DSO values</P> <P>Above(<BR />Avg({1&lt;fiscper&gt;}Aggr(avg({1&lt;fiscper&gt;}Aggr({1&lt;fiscper&gt;}distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor)),12)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="swathi5_0-1726557353014.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171753iD64D51CC8155E444/image-size/medium?v=v2&amp;px=400" role="button" title="swathi5_0-1726557353014.png" alt="swathi5_0-1726557353014.png" /></span></P> <P>&nbsp;</P> <P>previous year DSO formula is working fine where there no selection on fiscper, when selecting fiscper it is not giving correct ouptut. when i filtered 2022-01, it need to show 2021-01 value, but it giving something 2023-01 , but value showing again 2022-01. kindly help me</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="swathi5_1-1726557630414.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171754iC99A74E30F787562/image-size/medium?v=v2&amp;px=400" role="button" title="swathi5_1-1726557630414.png" alt="swathi5_1-1726557630414.png" /></span></P> <P>&nbsp;</P> Fri, 15 Nov 2024 20:52:10 GMT https://community.qlik.com/t5/App-Development/need-to-CY-vs-PY-Values-in-Line-chart/m-p/2481961#M100883 swathi5 2024-11-15T20:52:10Z