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.
