topic Re: separate values in a table in QlikView

separate values in a table

Wed, 04 Nov 2015 12:43:19 GMT

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.

Re: separate values in a table

Anonymous — Wed, 04 Nov 2015 13:11:50 GMT

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)

Re: separate values in a table

Wed, 04 Nov 2015 13:23:43 GMT

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.

Re: separate values in a table

Anonymous — Wed, 04 Nov 2015 13:30:53 GMT

Please, do not duplicate questions:

calculate per year

Re: separate values in a table

alexandros17 — Wed, 04 Nov 2015 13:48:11 GMT

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

Re: separate values in a table

Kushal_Chawda — Wed, 04 Nov 2015 13:53:53 GMT

Use Pivot Table