Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Totalize

Year   2015                                2014

Cars   Toyota Opel Mitsubishi   Toyota Opel Mitsubishi

Okt.     10        20       30              10       40    50

Sept.   5          1          4                 5        3      2

etc.

Now i want to totalize The specific cars.

see line total1

Year   2015                                2014

Total1  15        21       34             15       43    52

Cars   Toyota Opel Mitsubishi   Toyota Opel Mitsubishi

Okt.     10        20       30              10       40    50

Sept.   5          1          4                 5        3      2

etc.

How can i fix this?

1 Reply
jolivares
Specialist
Specialist

This is easy, if you want to totalize, create a pivot table with Month, CarsTradeMark, Year as a dimension and an expression sum(unitsales).  Pivot your table year and CarsTradeMark and that's it.

But If you want to see your data in that specific model, maybe you have to create an special mode to see your data, maybe creating anothe table with total only.