topic Expression Help - different facts in QlikView https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237690#M88714 <HTML><HEAD></HEAD><BODY><P>right because I need it to ignore any selections for Sales Year but still be able to pivot it on that year</P></BODY></HTML> Thu, 03 Mar 2011 22:35:03 GMT avastani 2011-03-03T22:35:03Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237685#M88709 <HTML><HEAD></HEAD><BODY><P>I am trying to create a table to obtain the number of weeks of Inventory data by Product Category and Sales Year given the datamodel here. The problem is that I have only partial weeks of data for 2010 and 2011 but I keep getting 53 as my number of weeks of inventory for my category which is incorrect.</P><P>My expression is simple</P><P>COUNT({SalesYear=, SalesMonth=, SalesQuarter=, SalesDate=} DISTINCT InventoryWeek)</P><P>What am I missing here? I asked the expression to ignore SalesYear but I am trying to pivot it on SalesYear and asking it to treat SalesYear as InventoryYear.. How can I do this? You can see if I pivot this on InventoryYear, I get the proper results.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3708_sourceID:3708" /></P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3709_sourceID:3709" /></P></BODY></HTML> Thu, 03 Mar 2011 16:20:27 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237685#M88709 avastani 2011-03-03T16:20:27Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237686#M88710 <HTML><HEAD></HEAD><BODY><P>Hi there all,</P><P>any takers on this question?</P></BODY></HTML> Thu, 03 Mar 2011 20:56:39 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237686#M88710 avastani 2011-03-03T20:56:39Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237687#M88711 <HTML><HEAD></HEAD><BODY><P>Hi Amir,</P><P>what ist wrong with 53 weeks in 2009?? Some years have 53 weeks..</P><P>-- Ralf</P></BODY></HTML> Thu, 03 Mar 2011 22:21:06 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237687#M88711 rbecher 2011-03-03T22:21:06Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237688#M88712 <HTML><HEAD></HEAD><BODY><P>yes but if I am in mid year, I have data for only partial weeks for Inventory</P></BODY></HTML> Thu, 03 Mar 2011 22:24:54 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237688#M88712 avastani 2011-03-03T22:24:54Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237689#M88713 <HTML><HEAD></HEAD><BODY><P>You have no selection for SalesYear: {SalesYear=</P><P></P></BODY></HTML> Thu, 03 Mar 2011 22:30:07 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237689#M88713 rbecher 2011-03-03T22:30:07Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237690#M88714 <HTML><HEAD></HEAD><BODY><P>right because I need it to ignore any selections for Sales Year but still be able to pivot it on that year</P></BODY></HTML> Thu, 03 Mar 2011 22:35:03 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237690#M88714 avastani 2011-03-03T22:35:03Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237691#M88715 <HTML><HEAD></HEAD><BODY><P>But then the Count goes over all years. Remove this condition. I don't know why you have this set analysis...</P></BODY></HTML> Thu, 03 Mar 2011 22:37:51 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237691#M88715 rbecher 2011-03-03T22:37:51Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237692#M88716 <HTML><HEAD></HEAD><BODY><P>do you think the data model would need to be revised then. because if I select a sales year, then my data for Inventory will not be independent of Sales Year anymore.</P></BODY></HTML> Thu, 03 Mar 2011 22:39:56 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237692#M88716 avastani 2011-03-03T22:39:56Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237693#M88717 <HTML><HEAD></HEAD><BODY><P>I see, then I would suggest to have three expressions:</P><P>Weeks2009: COUNT(1&lt;SalesYear= {2009} &gt;} ...<BR />Weeks2010: COUNT(1&lt;SalesYear= {2010} &gt;} ...<BR />Weeks2011: COUNT(1&lt;SalesYear= {2011} &gt;} ...</P></BODY></HTML> Thu, 03 Mar 2011 22:44:00 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237693#M88717 rbecher 2011-03-03T22:44:00Z Expression Help - different facts https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237694#M88718 <HTML><HEAD></HEAD><BODY><P>Another solution could be to decouple the tables...</P></BODY></HTML> Thu, 03 Mar 2011 22:48:23 GMT https://community.qlik.com/t5/QlikView/Expression-Help-different-facts/m-p/237694#M88718 rbecher 2011-03-03T22:48:23Z