topic Re: Composite Key in QlikView

Composite Key

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

Hi Experts,

I have Created Composite key . i am getting result in list box like .

1/1/20161/2/20161/3/2016

But I need

1/1/2016

1/2/2016

1/3/2016

is it possible.

Re: Composite Key

sunny_talwar — Fri, 15 Jul 2016 10:33:19 GMT

How does you load statement look like?

Re: Composite Key

qlikview979 — Fri, 15 Jul 2016 10:34:47 GMT

Hi Sunny,

Date&Date1&Date2 as key

Re: Composite Key

tresB — Fri, 15 Jul 2016 10:40:26 GMT

Perhaps you need to Concatenate them like:

Load Date From <>;

Concatenate

Load Date1 From <>;

Concatenate

Load Date2 From <>;

Re: Composite Key

qlikview979 — Fri, 15 Jul 2016 10:43:35 GMT

Hi tresesco,

I am getting all date field in only one table

Re: Composite Key

tresB — Fri, 15 Jul 2016 10:48:56 GMT

To get all dates field into a single date field you can try the way I suggested. You can refer the same table multiple times for multiple fields, that would not be an issue. But now I suspect, that alone would not resolve your business issue. You have to re-visit your data modelling.

Perhaps the following blogs can help here:

Canonical Date

Why You sometimes should Load a Master Table several times