Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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!

Tags (4)
1 Solution

Accepted Solutions
MVP
MVP

Re: Display Aggregated Count per Week on a Table Chart

2 Replies
MVP
MVP

Re: Display Aggregated Count per Week on a Table Chart

Re: Display Aggregated Count per Week on a Table Chart

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)