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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.