Not fully expanded on a "Table" (not Pivot Table)

ipavlo — Sat, 16 Nov 2024 18:36:25 GMT

Hi Qlik community, I am new to Qlik and i am trying to find if possible to have a NOT fully expanded presentation on a Table. I am aware how to change between the two views in a Pivot Table but i would like to achieve this on a Table (basically achieve the same affect as Tabular Form in Excel).

So for example currently i have this:

Category Speed

Red Car 51 km/h

Red Car 32 km/h

Red Car 71 km/h

Blue Car 88 km/h

Blue Car 91 km/h

And i need to get have this:

Category Speed

Red Car 51 km/h

32 km/h

71 km/h

Blue Car 88 km/h

91 km/h

The reason i am using a Table instead of Pivot table is that i will need to be able to change formatting of specific value which i was not able to make it work by using a pivot table. For example i would like to have the value "Red Car" formatted with red color while the "Blue Car" as blue.

Thanks in advance

topic Not fully expanded on a "Table" (not Pivot Table) in App Development

Not fully expanded on a "Table" (not Pivot Table)