Sum Of Field in Chart

[Anonymous]

Hi,

I have following data set in excel which i load in qlikview

TicketNo	AssignmentGroup	CreationDate	ResolveDate
T0001	Group1	12/12/2016	14/12/2016
T0002	Group2	15/12/2016	17/12/2016
T0003	Group3	19/12/2016	25/12/2016
T0004	Group4	30/12/2016	02/01/2017

Ticket:

LOAD TicketNo,

     AssignmentGroup,

     CreationDate,

     ResolveDate,

FROM

[..\IncData.xlsx]

When i try to create a bar chart with dimension as AssignmentGroup and Expression as Sum(TicketNo) I get No Data.

How do i create a chart which shows ticket count per assignment group?

Thank you.

[sunny_talwar]

You can only Sum numeric data.... since TicketNo is not numeric (and you are looking to count), I would suggest using Count() function here....

Count(TicketNo)

[satheshreddy]

hi Su,

you are not able to perform sum() why because ticket no are alphanumeric sum function it do only numeric values.

you can use count of tickets based on group dimension.

Dimension : AssignmentGroup

Exp: count(TicketNo)  

Regards

Sathish

[#4]

use count(TicketNo)  instead of Sum(TicketNo)

[saimahasan]

As suggested by all, use Count(Ticket no).

If this satisfies your requirement then please mark it as answered.