Hi All,
Need some help figuring out how to create a combo bar/line graph in Qlik Sense.
My bars will be the total for each column in the below; then I'd like multiple, differently colored lines for the different AGENTTYPEs on the left side and the # represented for each column. Is this possible?
Each column references a session (QLIK_SESS)
Each # within session is the Total FTEs (sum(QLIK_FTE))
AGENTTYPE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
Agents | 48,468.73 | 46,110.72 | 47,378.34 | 49,630.10 | 48,430.04 | 47,196.10 | 55,251.49 | 56,544.76 | 48,505.25 | 53,318.41 | 55,453.37 | 54,157.04 | 43,603.07 | 1,770.57 |
B2C | 361.82 | 337.33 | 328.08 | 297.42 | 238.50 | 209.72 | 256.50 | 325.11 | 359.17 | 393.13 | 432.83 | 424.58 | 326.98 | 40.44 |
DOM | 16,749.36 | 19,393.18 | 19,443.38 | 19,627.50 | 18,280.55 | 16,948.09 | 17,048.44 | 16,742.65 | 16,561.40 | 19,748.78 | 20,690.95 | 19,631.78 | 14,658.17 | 782.17 |
OVE | 6,356.88 | 6,879.53 | 7,311.21 | 7,369.33 | 7,030.93 | 6,743.68 | 7,144.68 | 7,327.40 | 6,666.55 | 7,340.53 | 7,741.90 | 7,438.95 | 5,919.35 | 364.80 |
Totals | 71937.8 | 72722.8 | 74464.0 | 76928.3 | 73985.0 | 71103.6 | 79708.1 | 80947.9 | 72101.4 | 80810.8 | 84330.0 | 81664.3 | 64520.6 | 2972.0 |