topic Re: How to write expression in chart item in QlikView

How to write expression in chart item

Thu, 23 Jan 2014 14:06:01 GMT

Hi,

Could any one help me below.

please find attached and I need to show

A chart item which lists each person in the team , and the number of work items they have closed. In addition to that I need a breakdown of the individual work item types each individual closed. For example something as basic as:

Name Total Work Items closed Work Item Type Total

Seanne 3 Authorised missed payment 2

PPI 1

Please can anyone helpme with chart item ecpressions please.

thanks.

Re: How to write expression in chart item

salto — Thu, 23 Jan 2014 14:23:14 GMT

Hi Amelia,

not exactly what you asked for attached goes an example.

Regards.

Re: How to write expression in chart item

Anonymous — Thu, 23 Jan 2014 14:27:32 GMT

Use calculated dimension for the 2nd column - see attached.

(And please reduce the file before uploading next time)

Re: How to write expression in chart item

Or — Thu, 23 Jan 2014 14:30:19 GMT

Use the following calculated dimension:

=aggr(count(DISTINCT WorkItemType),Name)

Re: How to write expression in chart item

Thu, 23 Jan 2014 15:17:19 GMT

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

Re: How to write expression in chart item

Thu, 23 Jan 2014 15:17:28 GMT

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

Re: How to write expression in chart item

Thu, 23 Jan 2014 15:18:33 GMT

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

Re: How to write expression in chart item

Anonymous — Thu, 23 Jan 2014 15:23:05 GMT

Why three times???

the first dimension will be Who, and the 2nd (calculated):

aggr(count(WorkItemType),Who)

Re: How to write expression in chart item

Thu, 23 Jan 2014 15:41:39 GMT

Thanks and suppose if I want to get these items for

where DateLogged>29/01/2012

how can I give? please help

Re: How to write expression in chart item

ThornOfCrowns — Thu, 23 Jan 2014 15:52:25 GMT

If you amend the values in your reply from Name to Who, you do not get anything returned in the first column. There's a disjunct between Name and Who, i.e. they aren't linked.

If you look at a preview of the Link Table, you'll see that there are no WorkItems listed against the "Who" data rows. This is the problem that needs to be addressed, I think. Amelia D

Re: How to write expression in chart item

Anonymous — Thu, 23 Jan 2014 15:58:50 GMT

Yes James, you're right - there are no WorkItemType data for "Who".

Amelia, stay with "Name" or rebuild your data model first.

Re: How to write expression in chart item

Thu, 23 Jan 2014 16:09:02 GMT

Yes James and you are right that's the problem I was facing since long time. Is there any way I can change the data model as I tried in many wmays but nothing is working.