Composite Key

[qlikview979]

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.

[sunny_talwar]

How does you load statement look like?

[qlikview979]

Hi Sunny,

like

Date&Date1&Date2 as key

[tresesco]

Perhaps you need to Concatenate them like:

Load Date From <>;

Concatenate

Load Date1 From <>;

Concatenate

Load Date2 From <>;

[qlikview979]

Hi tresesco,

I  am getting all date field in only one table

[tresesco]

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