Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
swathi5
Contributor
Contributor

need to CY vs PY Values in Line chart

i have dso and fiscper fields, creating line chart to show dso values of all fiscper and corresponding previous year fiscper values.

DSO formula to should all fiscper values

Avg(Aggr(avg(Aggr(distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor))

iam using below function to get previous year DSO values

Above(
Avg({1<fiscper>}Aggr(avg({1<fiscper>}Aggr({1<fiscper>}distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor)),12)

swathi5_0-1726557353014.png

 

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

swathi5_1-1726557630414.png

 

Labels (2)
0 Replies