Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to develop dashboard on YOY Growth.
i need to show monthly value chnage on X -Axis compared to current year value with the last year sametimeperiod.
--need to show highest value for each month not the sum.
i used firstsortedvalue and got the results as long month is complete and when data is in between month issue as i have max value for previous year value but not current year
ex: 2019 may 10
2018 has data for all the days 365 days
my expression=(FirstSortedValue(DISTINCT Aggr(Sum(sales),Month,PeriodDate),- PeriodDate) -(ABOVE(FirstSortedValue(DISTINCT Aggr(Sum(sales),Month,PeriodDate),- PeriodDate)))
iam getting right output for the Jan,feb,march,april but for May i am getting wrong one as i am taking highest value for the month data as may31 instead of may10 for the previous year compared to the curent year
Have you try adding year within Aggr() function and check it.
If the above post was what you needed, please be sure to use the Accept as solution button to mark that as the solution. If not, check out the following link, believe that should likely have everything you need to get things sorted out.
https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927
Regards,
Brett