https://community.qlik.com/t5/QlikView/Dimension-using-set-analysis-or-calculated-field-consisting/m-p/1533506#M438950 <P>I am Trying to create a dimension using these fields. But i just want data for latest "n" dates.</P><P>I want to used the Table&nbsp; field name on x axis with respect to last three dates per field.&nbsp;</P><P>&nbsp;</P><P>and I could not conclude as I am new but I have come across how to parse date field in rfc format.&nbsp;</P><P>&nbsp;</P><P><A href="https://community.qlik.com/t5/QlikView-Scripting/Parse-ISO8601-rfc3339-Date/td-p/273026" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Parse-ISO8601-rfc3339-Date/td-p/273026</A></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table1_Field_NAME</TD><TD>Table2_Field_DATE</TD></TR><TR><TD>FIELD_A_01.1903_DB04</TD><TD>2019-01-07T03:13:42+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB05</TD><TD>2019-01-08T03:12:09+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB06</TD><TD>2019-01-09T03:12:45+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB07</TD><TD>2019-01-10T03:08:46+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB01</TD><TD>2019-01-11T03:08:07+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB03</TD><TD>2019-01-13T03:06:03+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB04</TD><TD>2019-01-14T03:09:21+01:00</TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1904_DB06</FONT></TD><TD><FONT color="#99CC00">2019-01-16T03:08:57+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1904_DB07</FONT></TD><TD><FONT color="#99CC00">2019-01-17T03:12:40+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1905_DB01</FONT></TD><TD><FONT color="#99CC00">2019-01-18T03:12:56+01:00</FONT></TD></TR><TR><TD>FIELD_B_01.1903_DB04</TD><TD>2019-01-07T03:13:42+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB05</TD><TD>2019-01-08T03:12:09+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB06</TD><TD>2019-01-09T03:12:45+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB07</TD><TD>2019-01-10T03:08:46+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB01</TD><TD>2019-01-11T03:08:07+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB03</TD><TD>2019-01-13T03:06:03+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB04</TD><TD>2019-01-14T03:09:21+01:00</TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1904_DB06</FONT></TD><TD><FONT color="#99CC00">2019-01-16T03:08:57+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1904_DB07</FONT></TD><TD><FONT color="#99CC00">2019-01-17T03:12:40+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1905_DB01</FONT></TD><TD><FONT color="#99CC00">2019-01-18T03:12:56+01:00</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" style="width: 408px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4267iD515DE82F14FAA21/image-dimensions/408x543?v=v2" width="408" height="543" role="button" title="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" alt="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" /></span></P> Sat, 16 Nov 2024 04:41:40 GMT wiz_nerd 2024-11-16T04:41:40Z https://community.qlik.com/t5/QlikView/Dimension-using-set-analysis-or-calculated-field-consisting/m-p/1533506#M438950 <P>I am Trying to create a dimension using these fields. But i just want data for latest "n" dates.</P><P>I want to used the Table&nbsp; field name on x axis with respect to last three dates per field.&nbsp;</P><P>&nbsp;</P><P>and I could not conclude as I am new but I have come across how to parse date field in rfc format.&nbsp;</P><P>&nbsp;</P><P><A href="https://community.qlik.com/t5/QlikView-Scripting/Parse-ISO8601-rfc3339-Date/td-p/273026" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Parse-ISO8601-rfc3339-Date/td-p/273026</A></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table1_Field_NAME</TD><TD>Table2_Field_DATE</TD></TR><TR><TD>FIELD_A_01.1903_DB04</TD><TD>2019-01-07T03:13:42+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB05</TD><TD>2019-01-08T03:12:09+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB06</TD><TD>2019-01-09T03:12:45+01:00</TD></TR><TR><TD>FIELD_A_01.1903_DB07</TD><TD>2019-01-10T03:08:46+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB01</TD><TD>2019-01-11T03:08:07+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB03</TD><TD>2019-01-13T03:06:03+01:00</TD></TR><TR><TD>FIELD_A_01.1904_DB04</TD><TD>2019-01-14T03:09:21+01:00</TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1904_DB06</FONT></TD><TD><FONT color="#99CC00">2019-01-16T03:08:57+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1904_DB07</FONT></TD><TD><FONT color="#99CC00">2019-01-17T03:12:40+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_A_01.1905_DB01</FONT></TD><TD><FONT color="#99CC00">2019-01-18T03:12:56+01:00</FONT></TD></TR><TR><TD>FIELD_B_01.1903_DB04</TD><TD>2019-01-07T03:13:42+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB05</TD><TD>2019-01-08T03:12:09+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB06</TD><TD>2019-01-09T03:12:45+01:00</TD></TR><TR><TD>FIELD_B_01.1903_DB07</TD><TD>2019-01-10T03:08:46+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB01</TD><TD>2019-01-11T03:08:07+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB03</TD><TD>2019-01-13T03:06:03+01:00</TD></TR><TR><TD>FIELD_B_01.1904_DB04</TD><TD>2019-01-14T03:09:21+01:00</TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1904_DB06</FONT></TD><TD><FONT color="#99CC00">2019-01-16T03:08:57+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1904_DB07</FONT></TD><TD><FONT color="#99CC00">2019-01-17T03:12:40+01:00</FONT></TD></TR><TR><TD><FONT color="#99CC00">FIELD_B_01.1905_DB01</FONT></TD><TD><FONT color="#99CC00">2019-01-18T03:12:56+01:00</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" style="width: 408px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4267iD515DE82F14FAA21/image-dimensions/408x543?v=v2" width="408" height="543" role="button" title="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" alt="WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg" /></span></P> Sat, 16 Nov 2024 04:41:40 GMT https://community.qlik.com/t5/QlikView/Dimension-using-set-analysis-or-calculated-field-consisting/m-p/1533506#M438950 wiz_nerd 2024-11-16T04:41:40Z