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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator II
Creator II

In line chart Color code top 5 employee for each segment, and show the legends as well

Hi Below is the data I'm having

 

ORG Name Count of tickts
TCS A 100
TCS B 90
TCS C 80
TCS D 70
TCS E 60
CTS F 40
CTS G 30
CTS H 20
CTS I 10
Wipro J 8
Wipro K 7
Infy L 6
Infy M 5
Dell N 4

 

Based on the Count of the tickets, Employee might be 500 + 

 

But for each ORG 

I need to get Top 5 Employees and Colour code them

in the above example

I'm Plotting a line chart, by *date*

For TCS 

Top 5 employees,  based on count of tickets, by date

should be shown in a line chart and constant 5 colours should be plotted & even legends should be shown on the Top

In different chart for CTS, By date in x-axis, top 5 Employee based on count of tickets 

Qliksense is taking colour automatically, but they wanted to give constant 5 colors & show the legends as well

and those 5 colours should be same accross each segment, & show the legends as well

 

0 Replies