I am Trying to create a dimension using these fields. But i just want data for latest "n" dates.
I want to used the Table field name on x axis with respect to last three dates per field.
and I could not conclude as I am new but I have come across how to parse date field in rfc format.
https://community.qlik.com/t5/QlikView-Scripting/Parse-ISO8601-rfc3339-Date/td-p/273026
Table1_Field_NAME | Table2_Field_DATE |
FIELD_A_01.1903_DB04 | 2019-01-07T03:13:42+01:00 |
FIELD_A_01.1903_DB05 | 2019-01-08T03:12:09+01:00 |
FIELD_A_01.1903_DB06 | 2019-01-09T03:12:45+01:00 |
FIELD_A_01.1903_DB07 | 2019-01-10T03:08:46+01:00 |
FIELD_A_01.1904_DB01 | 2019-01-11T03:08:07+01:00 |
FIELD_A_01.1904_DB03 | 2019-01-13T03:06:03+01:00 |
FIELD_A_01.1904_DB04 | 2019-01-14T03:09:21+01:00 |
FIELD_A_01.1904_DB06 | 2019-01-16T03:08:57+01:00 |
FIELD_A_01.1904_DB07 | 2019-01-17T03:12:40+01:00 |
FIELD_A_01.1905_DB01 | 2019-01-18T03:12:56+01:00 |
FIELD_B_01.1903_DB04 | 2019-01-07T03:13:42+01:00 |
FIELD_B_01.1903_DB05 | 2019-01-08T03:12:09+01:00 |
FIELD_B_01.1903_DB06 | 2019-01-09T03:12:45+01:00 |
FIELD_B_01.1903_DB07 | 2019-01-10T03:08:46+01:00 |
FIELD_B_01.1904_DB01 | 2019-01-11T03:08:07+01:00 |
FIELD_B_01.1904_DB03 | 2019-01-13T03:06:03+01:00 |
FIELD_B_01.1904_DB04 | 2019-01-14T03:09:21+01:00 |
FIELD_B_01.1904_DB06 | 2019-01-16T03:08:57+01:00 |
FIELD_B_01.1904_DB07 | 2019-01-17T03:12:40+01:00 |
FIELD_B_01.1905_DB01 | 2019-01-18T03:12:56+01:00 |