Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write expression in chart item

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.

11 Replies
Specialist II
Specialist II

Hi Amelia,

not exactly what you asked for attached goes an example.

Regards.

Champion III
Champion III

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

(And please reduce the file before uploading next time)

Specialist III
Specialist III

Use the following calculated dimension:

=aggr(count(DISTINCT WorkItemType),Name)

Not applicable

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

Not applicable

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

Not applicable

Thanks and sorry I have to show Who instead of Name


Please help me how to change this.

Champion III
Champion III

Why three times???

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

aggr(count(WorkItemType),Who)

Not applicable

Thanks and suppose if I want to get these items for

where DateLogged>29/01/2012

how can I give? please help

Specialist II
Specialist II

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