topic Recurring names in QlikView

Recurring names

Learnerr — Mon, 26 Jan 2026 18:19:17 GMT

Good days,

I extract data from SQL.

In the Select section i have 2 fields called "Explanation" and "Group".

In the LOAD part i would like to combine both fields as they have similar parts within them. I wrote LOAD part like this:

LOAD Distinct

Explanation& Group as Groups

When i run this code in the front i create a listbox with the Field of "Groups" but it brings me double things under it.

Such as : Explanation and Group contains a field called linkedin and it shows in the list box as LinkedinLinkedin.

What can i do to prevent that double thing?

Thanks in advance.

Kind Regards.

anat — Mon, 31 Jan 2022 07:13:05 GMT

Explanation& Group as Groups

means you will get below output

Explanation, Group,Explanation& Group

1,2,12

Linkedin,Linkedin,LinkedinLinkedin

A,B,AB

1,1,11

if you want distinct values in seperate field

load Explanation as Groups from table

concatenate

load Group as Groups from table

Learnerr — Mon, 31 Jan 2022 11:03:08 GMT

Dear anat;

I wrote my code like this but it doesnt work:

CONCATENATE

Table:
Load Distinct
MenuId,
Explanation as Groups,

Group as Groups

;
SELECT
MenuId,
Explanation,
Group

FROM XYZ

anat — Mon, 31 Jan 2022 11:07:03 GMT

Table:
Load Distinct
MenuId,
Explanation as Groups,

Group as Groups

;
SELECT
MenuId,
Explanation,
Group

FROM XYZ

qlik will not accept same name twice in single load script.

Learnerr — Mon, 31 Jan 2022 11:09:04 GMT

Yes, but how can i combine both of them ?