topic Sum Of Field in Chart in QlikView

Sum Of Field in Chart

Anonymous — Tue, 03 Jan 2017 01:01:09 GMT

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 — Tue, 03 Jan 2017 03:39:28 GMT

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 — Tue, 03 Jan 2017 03:48:26 GMT

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

Tue, 03 Jan 2017 06:07:32 GMT

use count(TicketNo) instead of Sum(TicketNo)

saimahasan — Tue, 03 Jan 2017 09:31:19 GMT

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

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