topic Re: Composite key in QlikView

Composite key

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview community,

When I change 4 keys into 1 composite key in qlikview script do I have still access to each original key individually from for example the Dashbord (as selection fields used as dimentions)? .

I want to create the composite key in order to remove a synthetic Table added by qlikview.

Thank you,

Abdallah

Re: Composite key

Anil_Babu_Samineni — Tue, 08 May 2018 13:44:40 GMT

Yes

Re: Composite key

absekrafi — Tue, 08 May 2018 13:57:38 GMT

Thank you Anil

Re: Composite key

absekrafi — Tue, 08 May 2018 14:45:58 GMT

Hi Anil,

I checked the composite key value I found repeated value. Do you know how to fix that?

Also, do I have to drop the fields I used to create the composite key?

Thanks,

Re: Composite key

Anil_Babu_Samineni — Tue, 08 May 2018 15:03:16 GMT

I wonder, How you get repeated value. Can you show the image

Do you have Link Table? If so, You can use DROP statement

Re: Composite key

absekrafi — Wed, 09 May 2018 08:20:26 GMT

Re: Composite key

absekrafi — Wed, 09 May 2018 08:23:01 GMT

In the image above, CodesKeyNumber = 1 and CodesKeyNumber = 2 is repeated.

1- SOUFRE

1- A.P.54%

and

2- Ammoniac

2- A.P.Total

Re: Composite key

absekrafi — Wed, 09 May 2018 08:24:12 GMT

23 and 24 codes as well:

Re: Composite key

Anil_Babu_Samineni — Wed, 09 May 2018 08:32:40 GMT

You should look Row level? What is the problem with 23 and 24 and left of ??

Re: Composite key

jonathandienst — Wed, 09 May 2018 08:40:51 GMT

Is CodesKeyNumber an autonumbered version of CodesKey? It seems that the autoumbering is ignoring leading or trailing dashes, so --1-2 and 1-2-- get the same number. I suggest that you change dashes to pipes: ||1|2 and 1|2||.