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: 
Sxbbb
Creator III
Creator III

I want the Duration information (green line) to be separated by each Machine name.

I want the Duration information (green line) to be separated by each Machine name. Currently, the green line is in the middle for all machines and not separated by each MC point."

Sxbbb_0-1755940433026.png

Sxbbb_3-1755940479838.png

Justify_EquipmentNo_Display &' - '& Shift as Jus_MC,

 

Sxbbb_1-1755940446479.pngSxbbb_2-1755940459516.png

Sxbbb_4-1755940485848.png

 

 

1 Reply
Chanty4u
MVP
MVP

Try this 

Avg({<Year = {'$(=Max(Year))'}>} TOTAL <Jus_MC> Duration)

Avg(Duration) → per machine (separated green line)

 

Avg(TOTAL Duration) → overall reference line