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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner - Creator III
Partner - Creator III

Reverse count in Line-Charts with "buckets"

Hi all,

Can anybody help?

Need to reverse the counting of "buckets" in a line-chart. X-axis are hours. E.g. hour 10 has 7 accumulations. It accumulates the counts from 10-11 a.m. (left to right). I would like to have the opposite. To count from right to left, Hour 10 should show 5. 

Tried with the above and below function, but couldn't find the solution. As I am using master items, believe this should be handled in the chart object itself and not in a master item / variable which could have impact to other calculations.

2019.1223-110943.jpg

 

Thank for any input.

George

2 Replies
sunny_talwar

Would you be able to share a sample app to show the issue?

george55
Partner - Creator III
Partner - Creator III
Author

Please find attached. There are other data then my first screenshot but hope you should be able to handle it.

Thanks