Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

Date Formatting Issue

Good morning folks,

I'm trying to match two tables using a Key so that I can get my records to be a little more unique.  I'm having an issue with my date field within the key and not sure what I'm doing wrong.

  • When I load my data, my [Transaction Date] looks normal:  12/06/2019
  • When add the transaction date to my key the date is coming out as:  43805

This is the key I'm creating:  [Employee ID] & [Transaction Date] & [Transaction Amount] as MatchKey

The source of data is a spreadsheet.

I have seen this happen in Excel, but not in QV.

Is there something the QV is interpreting that I'm not understanding/formatting correctly?

Appreciate your input....thanks, George

Labels (2)
1 Solution

Accepted Solutions
eddie_wagt
Partner
Partner

QV recognizes the field as numeric including the date. Numeric (integer) is better for using as a key. You can however let Qlik know you want a text field (ascii), by specifying that the field is a date.

[Employee ID] & date([Transaction Date]) & [Transaction Amount]  as MatchKey

View solution in original post

2 Replies
eddie_wagt
Partner
Partner

QV recognizes the field as numeric including the date. Numeric (integer) is better for using as a key. You can however let Qlik know you want a text field (ascii), by specifying that the field is a date.

[Employee ID] & date([Transaction Date]) & [Transaction Amount]  as MatchKey

gfisch13
Creator II
Creator II
Author

Worked perfectly, appreciate the clarification and instruction!!  Thank you!!