Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Display Aggregated Count per Week on a Table Chart

Hi, I would like to ask if it's possible to create a table chart that aggregates the count of an equipment per classification on a weekly basis.

Supposedly I have a table with the following data:

Equipment, Classification, Week

Equip_1, Class_1, 201701

Equip_2, Class_1, 201701

Equip_3, Class_2, 201701

Equip_4, Class_4, 201701

Equip_5, Class_2, 201701

Equip_1, Class_2, 201702

Equip_2, Class_1, 201702

Equip_3, Class_2, 201702

Equip_4, Class_4, 201702

Equip_5, Class_3, 201702

I want to display this in a table chart like this:

Classification201701201702
Class_121
Class_222
Class_301
Class_411

Thanks in advance!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

2 Replies
Highlighted
MVP
MVP

Highlighted

Use, Pivot table with the expression of Count(Equipment) and Dim as Classification & Week. Then transpose to Row for Week

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)