topic Re: Duplicate Issue in QlikView

Duplicate Issue

tamilarasu — Tue, 21 Apr 2015 05:32:30 GMT

Hi,

I have the below expression to concatenate two columns. But after concatenating again I got duplicate values. Can any one suggest me a expression.

= ( concat(distinct Shift_WD ,',') & ',' & Concat(Distinct Shift_Calculated,','))

Say for example, I have to remove Shift 4 in chart, (Shift 4 is present in Columns Shift_WD & Shift_Calculated)

Shift 1,Shift 4,Shift 4,Shift Issue

Thank you

SergeyMak — Tue, 21 Apr 2015 05:44:50 GMT

Hi Tamil,

It would be good to have a look at your app.

Could you share it?

Regards,

Sergey

tamilarasu — Tue, 21 Apr 2015 05:51:56 GMT

Hi Sergey,

Thanks for the prompt response. Sorry. I am not allowed to share the data. Is it possible to remove duplicate values in a cell.?

jonathandienst — Tue, 21 Apr 2015 05:58:45 GMT

Something like this should work:

=Concat(DISTINCT Shift_WD, ',') & ',' & Concat({<Shift_Calculated -= P(Shift_WD)>} DISTINCT Shift_Calculated, ',')

HTH

Jonathan

SergeyMak — Tue, 21 Apr 2015 05:59:47 GMT

Yeah,

I believe so, but I can't say anything in this case without your app.

Try to replicate the problem with dummy data and share it or just use Scrambling in document properties.

Regards,

Sergey