topic Re: Two tables with sales and calls data in QlikView https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838144#M1016361 <HTML><HEAD></HEAD><BODY><P>I might need some more information on what type of chart you are using or expressions but it sounds like you are making selections in your document that only have possible values for employees that have sales. Maybe your calendar is based on sales data or something similar. Also your document might be storing your last session state, that is the selections that you had when you closed it. There are quite a few things that could be causing this. What selections are already made when you enter the document?</P></BODY></HTML> Thu, 02 Apr 2015 08:19:07 GMT Anonymous 2015-04-02T08:19:07Z Two tables with sales and calls data https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838141#M1016357 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have <STRONG>Sales</STRONG> and <STRONG>calls</STRONG> tables linked to an <STRONG>employee</STRONG> table. There are employees which have <SPAN style="text-decoration: underline;">calls so far and not a sale</SPAN>.</P><P></P><P>When the QVD is run in the QMC job, it filters down the calls grids/graphs to only those employees who have sales. then I have to hit Clear ALL and then all employees show.</P><P></P><P>Why is it doing it and how can I fix it so all employees show either they have a sales or just calls.</P><P><BR /><IMG alt="Capture2.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/82725_Capture2.JPG" style="width: 620px; height: 306px;" /></P></BODY></HTML> Wed, 01 Apr 2015 16:13:25 GMT https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838141#M1016357 2015-04-01T16:13:25Z Re: Two tables with sales and calls data https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838142#M1016358 <HTML><HEAD></HEAD><BODY><P>sounds like you have a trigger that might be applying a filter </P></BODY></HTML> Wed, 01 Apr 2015 16:21:09 GMT https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838142#M1016358 ramoncova06 2015-04-01T16:21:09Z Re: Two tables with sales and calls data https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838143#M1016359 <HTML><HEAD></HEAD><BODY><P>No there are no triggers</P></BODY></HTML> Wed, 01 Apr 2015 16:28:30 GMT https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838143#M1016359 2015-04-01T16:28:30Z Re: Two tables with sales and calls data https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838144#M1016361 <HTML><HEAD></HEAD><BODY><P>I might need some more information on what type of chart you are using or expressions but it sounds like you are making selections in your document that only have possible values for employees that have sales. Maybe your calendar is based on sales data or something similar. Also your document might be storing your last session state, that is the selections that you had when you closed it. There are quite a few things that could be causing this. What selections are already made when you enter the document?</P></BODY></HTML> Thu, 02 Apr 2015 08:19:07 GMT https://community.qlik.com/t5/QlikView/Two-tables-with-sales-and-calls-data/m-p/838144#M1016361 Anonymous 2015-04-02T08:19:07Z