Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

0 Replies