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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Plot max count of occurance

Hi All,

There are four types of bands Hyper(86-9999999999999), High(70-85),Medium(30-69),Low(0-29). Data in timestamp. attached the file .Requirement is to display occurance of CPU in minute level, hour level,day level,week level.etc Every minute should plot one Band Display(if it is high then color for high band) Example: in 1 am  if 25 bands high,20 bands hyper,5 bands low and 10 bands  medium when i select Hour in cycle group at 1 am high band color should display and if drill down to minute level for that hour(1 am) 25 mins should have high band color bar, 20 bands hyper , 5 bands low and 10 bands medium.

Could anyone suggest me on this logic?

2 Replies
antoniotiman
Master III
Master III

Hi,

see attachment.

Regards,

Antonio

Anonymous
Not applicable
Author

Thanks a lot Antonio for the qvw. But one thing when i select hour it should have maximum band color ..but here both band color getting displayed. Only band that is appearing more times in minute level should appear in hour level. Is it possible in that way?