How can I create a chart of a dimension and its sum?

[#1]

Hi all,

I'm new to Qlikview and I'd like to create a simple chart with the x value being Job_ID and the x value being sum(Job_ID) ... I have been trying for a while but can't seem to be able to figure it out.

I've tried setting the dimension to Job_ID and the expression to sum(Job_ID) but that returns "no data to display"

Thanks in advance!

[#2]

Are you trying to Sum your dimension?

I think you need to have Job_ID as the dimension and sum(Value) as the expression.

Richard

[#3]

yes, I'm trying to chart the number of occurences of each Job_ID in my data.

sum(Value) does not seem to be valid ...

[#4 · Accepted solution]

try Count(Job_ID)

Richard

[#5]

Do you not want to do a Count(JobID) instead?

[#6]

sum(1) works fine ... on a related note ... only one of my values from Job_ID is showing .. can I show all of them at once?

[#7]

This works as well, Thanks.

but only one of my Job_IDs is showing ... can I show all of them at once on Qlikview?

[#8]

Not sure why, maybe you have one value selected in a listbox? You could post a sample file