Discussion Board for collaboration related to QlikView App Development.
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:
Thanks in advance!
View solution in original post
Use, Pivot table with the expression of Count(Equipment) and Dim as Classification & Week. Then transpose to Row for Week