How to show duplicate lines in table?

[#1]

Hi Community,

Can someone please guide me towards how to show duplicate lines in a chart? I'm attaching a sample sheet. Internal ID 460 shows Null in Parent ID even though Parent ID list box shows two IDs the reason being dupes are somehow displayed in Qlikview.

Thanks,

[swuehl]

If you want to show a line per parent ID, you need to add parent ID to your dimensions.

In general, whenever you are creating expressions, use aggregation functions, like

=Concat(DISTINCT POS.clientid,', ')

Use Aggregation Functions!

edit:

parent ID is represented by POS.clientid field, hence add this field to your dimensions.

As a side note, please try to limit the size of your QVW, e.g. by making an appropriate selection and then using File -> reduce data->keep possible values.

[Clever_Anjos · Accepted solution]

If you want to see into only a single line use concat(POS.clientid,'/')

If you want 2 lines, used POS.clientid as dimension

[#4]

Hi Stefan your formula is awesome but it squishes all the values in one column is there anyway I can have separate Internal IDs for all the different parent IDs.

Please shade some light!!!!!!

[swuehl]

As mentioned, you can create a second dimension

POS.clientid

[maxgro]

add POS.clientid as dimension in the chart

[#7]

Thanks everyone for your kind feedback. You guys are awesome every time I'm stuck you guys are there for assistance!!!!!!!!!!