Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

Dimension using set analysis or calculated field consisting STRING field with respect to DATE

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_NAMETable2_Field_DATE
FIELD_A_01.1903_DB042019-01-07T03:13:42+01:00
FIELD_A_01.1903_DB052019-01-08T03:12:09+01:00
FIELD_A_01.1903_DB062019-01-09T03:12:45+01:00
FIELD_A_01.1903_DB072019-01-10T03:08:46+01:00
FIELD_A_01.1904_DB012019-01-11T03:08:07+01:00
FIELD_A_01.1904_DB032019-01-13T03:06:03+01:00
FIELD_A_01.1904_DB042019-01-14T03:09:21+01:00
FIELD_A_01.1904_DB062019-01-16T03:08:57+01:00
FIELD_A_01.1904_DB072019-01-17T03:12:40+01:00
FIELD_A_01.1905_DB012019-01-18T03:12:56+01:00
FIELD_B_01.1903_DB042019-01-07T03:13:42+01:00
FIELD_B_01.1903_DB052019-01-08T03:12:09+01:00
FIELD_B_01.1903_DB062019-01-09T03:12:45+01:00
FIELD_B_01.1903_DB072019-01-10T03:08:46+01:00
FIELD_B_01.1904_DB012019-01-11T03:08:07+01:00
FIELD_B_01.1904_DB032019-01-13T03:06:03+01:00
FIELD_B_01.1904_DB042019-01-14T03:09:21+01:00
FIELD_B_01.1904_DB062019-01-16T03:08:57+01:00
FIELD_B_01.1904_DB072019-01-17T03:12:40+01:00
FIELD_B_01.1905_DB012019-01-18T03:12:56+01:00

 

WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg

Labels (2)
0 Replies