topic Re: Displaying record once for multiple rows in QlikView

Displaying record once for multiple rows

varunamin — Sat, 16 Nov 2024 19:26:44 GMT

Hi,

I have data displayed on left and need to display data as on the right. Thanks!

Lisa_P — Tue, 17 Dec 2019 03:10:15 GMT

If you create a pivot table with a measure it will work like this

varunamin — Tue, 17 Dec 2019 04:04:58 GMT

Hi Lisa,

I need it to be displayed in that format on Qlikview Dashboard. Is there any function that I need to write for it?

Lisa_P — Tue, 17 Dec 2019 04:30:15 GMT

You could try this:
Create a pivot table.

Dimension - ID1

Expression - Concat(ID2, chr(10)) - Label as ID2

This will group the ID1 values and in the next column list ID2 values separated by new line

rwunderlich — Tue, 17 Dec 2019 04:56:10 GMT

Create a Pivot Table with ID1 and ID2 as Dimensions. On the Presentation tab, Check "Always Fully Expanded" and uncheck "Suppress Zero Values".

-Rob

varunamin — Tue, 17 Dec 2019 15:55:35 GMT

Hi Lisa,

It is grouping all ids in ID2 in single row item for each ID1.

varunamin — Tue, 17 Dec 2019 17:11:47 GMT

Hi Rob,

"Always Fully Expanded" option is not present on Presentation tab. Thanks!

rwunderlich — Tue, 17 Dec 2019 18:55:19 GMT

You need to select Pivot Table as the Chart Type on the General tab.

-Rob

varunamin — Tue, 17 Dec 2019 19:38:31 GMT

Thanks! That worked.