Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tsagarrao
Contributor
Contributor

comparison of the current week total with previous week total in trend chart

Hi,

I would like to present the data trend in which it will compare with previous week. I have 12 weeks of the data, But I need to show latest 4 weeks data trend in chart. But the first week percentage is showing 0 always. for week12=week12 %-week11 %. But for 4th week from week 12 i.e week9 %, it is showing 0, though there is data for week8. I have used aggr(above(sum())) but it is presenting wrong numbers. pls help.

2 Replies
prat1507
Specialist
Specialist

HI

Can you plz provide a sample app?

Regards
Pratyush

tsagarrao
Contributor
Contributor
Author

Attached the sample, the highlited values are incorrect.