Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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