topic Help with Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Help-with-Pivot-Table/m-p/210366#M64972 <HTML><HEAD></HEAD><BODY><P>I have a pivot table similar to the attached example ...</P><P>We have a list of project customers who's sales (or lack of) we wish to monitor.</P><P>I need to display all customers whether they have sales or not.</P><P>I am working with two tables namely Customer and SalesInvoice.</P><P>I have two issues....</P><P>1) I want to suppress column E from appearing. I believe that this is appearing because customer "DEF Ltd" have had no sales. If I suppress zero values I lose customers that haven't had any sales - i need to display them. Does anyone know how I can suppress this column?</P><P>2) I want to highlight the month in which the customer was added to the project. I have tried to do this via changing the background colour in the expression if the month = project month. Because "DEF Ltd" has no sales, the cell is not being highlighted. Is there any way round this?</P><P>I have considered creating a sales record of £0.01 for every account but feel this could get quite complicated (this is just one view from the data I am extracting - there are several other fields extracted).</P><P>Any assistance greatly appreciated...</P></BODY></HTML> Wed, 13 Jan 2010 11:11:16 GMT pkelly 2010-01-13T11:11:16Z Help with Pivot Table https://community.qlik.com/t5/QlikView/Help-with-Pivot-Table/m-p/210366#M64972 <HTML><HEAD></HEAD><BODY><P>I have a pivot table similar to the attached example ...</P><P>We have a list of project customers who's sales (or lack of) we wish to monitor.</P><P>I need to display all customers whether they have sales or not.</P><P>I am working with two tables namely Customer and SalesInvoice.</P><P>I have two issues....</P><P>1) I want to suppress column E from appearing. I believe that this is appearing because customer "DEF Ltd" have had no sales. If I suppress zero values I lose customers that haven't had any sales - i need to display them. Does anyone know how I can suppress this column?</P><P>2) I want to highlight the month in which the customer was added to the project. I have tried to do this via changing the background colour in the expression if the month = project month. Because "DEF Ltd" has no sales, the cell is not being highlighted. Is there any way round this?</P><P>I have considered creating a sales record of £0.01 for every account but feel this could get quite complicated (this is just one view from the data I am extracting - there are several other fields extracted).</P><P>Any assistance greatly appreciated...</P></BODY></HTML> Wed, 13 Jan 2010 11:11:16 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Table/m-p/210366#M64972 pkelly 2010-01-13T11:11:16Z