Displaying record once for multiple rows

[varunamin]

Hi,

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

[Lisa_P]

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

[varunamin]

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]

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]

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]

Hi Lisa,

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

[varunamin]

Hi Rob,

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

[rwunderlich · Accepted solution]

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

-Rob

[varunamin]

Thanks! That worked.