topic Re: Values are repeating in one column in Straight Table In Qlik Sense in App Development

Values are repeating in one column in Straight Table In Qlik Sense

MS90 — Fri, 15 Nov 2024 21:29:39 GMT

1)Please find below details after loading data from data base to Qlik one column (Sold Code)is getting repeated values due to another columns (Sold ID) attached below details and

2)also due to more than 1million rows straight table is loading very slow how to optimise it by for loading data in table like initially only showing first 10000rows as pagination is not available in QS

Table in data base
Barcode(Keyfield)	Name	Country	Sold Ref	Sold Id
1	Gold	Canada	A1	100
1	Gold	Canada	A2	101
1	Gold	Canada	A3	102
1	Gold	Canada		103
1	Gold	Canada		104
1	Gold	Canada		105
2	Diamond	Dubai	B1	201
2	Diamond	Dubai		202
3	Silver	Aus	C1	301
3	Silver	Aus	C2	302
3	Silver	Aus		303
3	Silver	Aus		304
4	platinum	Uk	D1	401
4	platinum	Uk		402


After loading data in QS Straight Table
Barcode(Keyfield)	Name	Country	Sold QR Code	Sold Id
1	Gold	Canada	A1	100
1	Gold	Canada	A2	101
1	Gold	Canada	A3	102
1	Gold	Canada	A1	103
1	Gold	Canada	A2	104
1	Gold	Canada	A3	105
2	Diamond	Dubai	B1	201
2	Diamond	Dubai	B1	202
3	Silver	Aus	C1	301
3	Silver	Aus	C2	302
3	Silver	Aus	C1	303
3	Silver	Aus	C2	304
4	platinum	Uk	D1	401
4	platinum	Uk	D1	402

Re: Values are repeating in one column in Straight Table In Qlik Sense

edwin — Mon, 14 Aug 2023 19:30:32 GMT

1 million records for QLik Sense or QlikView is very small. what you are experiencing is a data model problem, you may want to paste your DM

Re: Values are repeating in one column in Straight Table In Qlik Sense

MS90 — Thu, 17 Aug 2023 16:13:36 GMT

Included script

included script

Re: Values are repeating in one column in Straight Table In Qlik Sense

Or — Thu, 17 Aug 2023 16:18:37 GMT

I'm not sure I follow here. Sold QR Code isn't the same field as Sold Ref in your first table. Additionally, your join appears to be based strictly on the Barcode field, and there are multiple rows with the same barcode, meaning if there is more than one QR code associated with each Barcode, you will inherently get duplication.

Re: Values are repeating in one column in Straight Table In Qlik Sense

MS90 — Thu, 17 Aug 2023 16:35:21 GMT

Sold ref in db is same column sold QR code in qs are same columns and key field is Bar code.

Sold Qrcode is not available for 103,104,105 values In sold I'd db but values duplicating in qs

Re: Values are repeating in one column in Straight Table In Qlik Sense

Or — Thu, 17 Aug 2023 17:11:23 GMT

Sold QR Code isn't linked to Sold Id, it's linked to Barcode...

Re: Values are repeating in one column in Straight Table In Qlik Sense

MS90 — Thu, 17 Aug 2023 17:16:18 GMT

Yes