topic Re: How to group by on a count(Filed name) expression in QlikView

How to group by on a count(Filed name) expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi , my source is below. I have a graph - where ticket count is shown by Month day ( Dimension as Month Day and Expression as Count(Ticket) - attached object.

I have 3 shifts - shift1,2,3 - is there a way i can stack the bar(ticket count) for each day by shift - ie each bar will have now 3 colors, each color for each shift - basically the idea is show the ticket count per shift for each day

Thank you

[DATA]:

LOAD Ticket,

[Assigned To],

[Assigned To] as Resource,

[Primary Affected CI],

Application,

[EON ID],

DOMAIN,

Opened,

Closed,

[Open Month],

[Close Month],

[Open Day],

[Date Open],

[Month Day],

[Date Close],

Updated,

State,

[Short Description],

[Work notes],

[Resolution List],

[Restoration Description],

[Assignment Group],

[Actual Severity],

[Time Taken],

Minutes,

Minutes as MinutesIM,

Hours,

[Ticket Open Time],

Shift

FROM

[ Data.xlsx]

(ooxml, embedded labels, table is [Page 1]);

Re: How to group by on a count(Filed name) expression

sunny_talwar — Thu, 07 Jul 2016 21:04:52 GMT

Have you tried adding Shift as your second dimension?

Re: How to group by on a count(Filed name) expression

trdandamudi — Thu, 07 Jul 2016 21:08:58 GMT

May be as attached:

Re: How to group by on a count(Filed name) expression

Fri, 08 Jul 2016 13:25:22 GMT

i have created these subset tables to have it work for njow - but was told to us 3 set analysis expressions as a better practise

[Shift1 Data]:

LOAD Shift, Number as Shift1_Number, [Open Month], [Month Day],

Hours as Shift1_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift1';

[Shift2 Data]:

LOAD Shift, Number as Shift2_Number, [Open Month], [Month Day],

Hours as Shift2_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift2';

[Shift3 Data]:

LOAD Shift, Number as Shift3_Number, [Open Month], [Month Day],

Hours as Shift3_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift3';

Re: How to group by on a count(Filed name) expression

Fri, 08 Jul 2016 13:25:36 GMT

i have created these subset tables to have it work for njow - but was told to us 3 set analysis expressions as a better practise

[Shift1 Data]:

LOAD Shift, Number as Shift1_Number, [Open Month], [Month Day],

Hours as Shift1_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift1';

[Shift2 Data]:

LOAD Shift, Number as Shift2_Number, [Open Month], [Month Day],

Hours as Shift2_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift2';

[Shift3 Data]:

LOAD Shift, Number as Shift3_Number, [Open Month], [Month Day],

Hours as Shift3_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift3';