topic Re: How to show duplicate lines in table? in QlikView

How to show duplicate lines in table?

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to show duplicate lines in table?

swuehl — Tue, 22 Mar 2016 18:29:35 GMT

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.

Re: How to show duplicate lines in table?

Clever_Anjos — Tue, 22 Mar 2016 18:33:03 GMT

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

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

Re: How to show duplicate lines in table?

Tue, 22 Mar 2016 18:47:42 GMT

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!!!!!!

Re: How to show duplicate lines in table?

swuehl — Tue, 22 Mar 2016 19:01:41 GMT

As mentioned, you can create a second dimension

POS.clientid

Re: How to show duplicate lines in table?

maxgro — Tue, 22 Mar 2016 19:17:39 GMT

add POS.clientid as dimension in the chart

Re: How to show duplicate lines in table?

Tue, 22 Mar 2016 20:40:29 GMT

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