Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

separate values in a table

Hi best friends!

I would like to create diagrams for each car brand for themselves and it should show a TOTAL value for each year , but the must important thing is to separate the brands so each diagram shows a single car brand with TOTAL & YEAR.

calc.png

5 Replies
Anonymous
Not applicable
Author

you can define Trellis (e.g. barchart: tab Dimension, button at bottom) for your Dimension brand

in straight table you get a table per Dimension (brand and year)

Not applicable
Author

Hi,

According to my understanding Pivot Table should fits your requirement,

where Car brand & year as dimension.

if not please give more explanation and sample output.

Anonymous
Not applicable
Author

Please, do not duplicate questions:

calculate per year

alexandros17
Partner - Champion III
Partner - Champion III

A trellis is a good option but I should use a pivot table because the large amounts of brands ...

Kushal_Chawda

Use Pivot Table