topic Re: Data/Table Manipulation & Expression in QlikView https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330069#M844225 <HTML><HEAD></HEAD><BODY><P>yes, i just created it for reference</P></BODY></HTML> Mon, 03 Apr 2017 13:26:17 GMT vinieme12 2017-04-03T13:26:17Z Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330062#M844215 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I upload some data like the following:</P><P></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Project ID&nbsp;&nbsp;&nbsp;&nbsp; Checkpoint&nbsp;&nbsp; Delivery Date</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/04/2017</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/06/2017</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/10/2017</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/05/2017</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/06/2017</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/07/2017</SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">I also have a master calendar<BR /></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">I want to display a table like the below:<BR /></SPAN></P><P>&nbsp; </P><TABLE><TBODY><TR><TD>Project ID</TD><TD>Checkpoint</TD><TD>Jan-17</TD><TD>Feb-17</TD><TD>Mar-17</TD><TD>Apr-17</TD><TD>May-17</TD><TD>Jun-17</TD><TD>Jul-17</TD><TD>Aug-17</TD><TD>Sep-17</TD><TD>Oct-17</TD><TD>Nov-17</TD></TR><TR><TD>001</TD><TD>1</TD><TD></TD><TD></TD><TD></TD><TD> 01/04/2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>001</TD><TD>2</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>01/06/2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>001</TD><TD>3</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>01/10/2017</TD><TD></TD></TR><TR><TD>002</TD><TD>1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>01/05/2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>002</TD><TD>2</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>01/06/2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>002</TD><TD>3</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> 01/07/2017</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330062#M844215 alwayslearning 2020-11-25T16:16:04Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330063#M844216 <HTML><HEAD></HEAD><BODY><P>See Attached APP</P><P><IMG alt="255759.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158682_255759.PNG" style="height: 144px; width: 620px;" /></P></BODY></HTML> Mon, 03 Apr 2017 12:14:46 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330063#M844216 vinieme12 2017-04-03T12:14:46Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330064#M844217 <HTML><HEAD></HEAD><BODY><P>Just Drag the YearMonth field from your Master Calendar, over your Expression, you will see blue reference lines that denote the position where the column will be dropped</P></BODY></HTML> Mon, 03 Apr 2017 12:21:44 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330064#M844217 vinieme12 2017-04-03T12:21:44Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330065#M844218 <HTML><HEAD></HEAD><BODY><P>You can still remove the null values so that do not show the bottom line.</P></BODY></HTML> Mon, 03 Apr 2017 12:22:23 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330065#M844218 ahaahaaha 2017-04-03T12:22:23Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330066#M844220 <HTML><HEAD></HEAD><BODY><P>This work for me.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 03 Apr 2017 13:12:07 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330066#M844220 alwayslearning 2017-04-03T13:12:07Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330067#M844222 <HTML><HEAD></HEAD><BODY><P>Just a follow up.</P><P></P><P>I want to highlight the values where the checkpoint date appears by colouring the cell.</P></BODY></HTML> Mon, 03 Apr 2017 13:19:48 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330067#M844222 alwayslearning 2017-04-03T13:19:48Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330068#M844223 <HTML><HEAD></HEAD><BODY><P>in background expression try</P><P></P><P>=if(not isnull(DeliveryDate),rgb(0,176,252))</P></BODY></HTML> Mon, 03 Apr 2017 13:25:54 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330068#M844223 vinieme12 2017-04-03T13:25:54Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330069#M844225 <HTML><HEAD></HEAD><BODY><P>yes, i just created it for reference</P></BODY></HTML> Mon, 03 Apr 2017 13:26:17 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330069#M844225 vinieme12 2017-04-03T13:26:17Z Re: Data/Table Manipulation & Expression https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330070#M844227 <HTML><HEAD></HEAD><BODY><P>Thanks again.</P><P></P><P>Just remembered to place that expression in the 'background colour' in the expression section. I was placing it across the whole table via custom format cell.</P></BODY></HTML> Mon, 03 Apr 2017 13:28:46 GMT https://community.qlik.com/t5/QlikView/Data-Table-Manipulation-Expression/m-p/1330070#M844227 alwayslearning 2017-04-03T13:28:46Z