Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Creating a KEY with datetime stamp and date

I created a Key to link the two sets of data but the second key is a date time stamp.

I need to convert it to just a date

need to remove time part of it

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Creating a KEY with datetime stamp and date

Try this:

Date(Floor([Checked]))&' , '&[CheckedBy] as Key,

4 Replies
sunny_talwar
Not applicable

Re: Creating a KEY with datetime stamp and date

What's the script used to create the key?

Not applicable

Re: Creating a KEY with datetime stamp and date

[Checked]&' , '&[CheckedBy] as Key,

sunny_talwar
Not applicable

Re: Creating a KEY with datetime stamp and date

Try this:

Date(Floor([Checked]))&' , '&[CheckedBy] as Key,

vinieme12
Not applicable

Re: Creating a KEY with datetime stamp and date

Floor(timestampfield) or Date(timestampfield,'YourDateFormat')