Bar chart help please

[#1]

Hi QlikView gurus,

I need to take the following data and represent it as a bar chart where an Avg between "LCL" and "UCL" is represented as green, an Avg between "LSL" and "LCL" or "UCL" and "USL" is represented in yellow, and an Avg that is out of range is represented in red. I probably need to take another QlikView class, because I don't think that this should be as difficult for me as it is. Please help!

[rubenmarin]

Hi Lee, you said "Is there a way to sort that column so that every day appears as 6:00 am through 5:59 am instead?", so '3/1/2016 5:36:52 am' should be at the bottom.

That's the weird thing I was saying, there is a gap of more than 24 hours with the next record, or.. how it must be sorted?

[#3]

Hi - I'm sorry if I wasn't clear. It should be sorted so that a "day" is 3/1/2016 6:00 am - 3/2/2016 5:59 am; the next "day" would be 3/2/2016 6:00 am - 3/3/2016 5:59 am, etc.

[rubenmarin]

Not sure if I'm misunderstanding something but this is the logical normal sort for a date, in 'Sort' tab try checking 'Numeric' so the order should be:

3/1/2016 6:00 am

3/1/2016 11:00 pm

3/2/2016 2:00 am

3/2/2016 5:59 am

3/2/2016 6:00 am

3/2/2016 12:00 pm

3/3/2016 5:59 am

[#5]

Oh wow. Thank you! I'm sorry I made that so complicated.