topic Multiple grains/facts... in QlikView https://community.qlik.com/t5/QlikView/Multiple-grains-facts/m-p/1164000#M379158 <HTML><HEAD></HEAD><BODY><P>I've been reading about Generic keys and other methods to combine multiple facts.&nbsp;&nbsp; Here's my situation.</P><P></P><P>We have facts at the country level (population, sq miles, etc).&nbsp; We also have facts at the customer level (sale, profit, trans. date).</P><P>Customer is in a country but a country may not have customers.</P><P></P><P>If we select country(s), we should get both country facts and customer facts for that selection.</P></BODY></HTML> Thu, 09 Jun 2016 15:39:52 GMT 2016-06-09T15:39:52Z Multiple grains/facts... https://community.qlik.com/t5/QlikView/Multiple-grains-facts/m-p/1164000#M379158 <HTML><HEAD></HEAD><BODY><P>I've been reading about Generic keys and other methods to combine multiple facts.&nbsp;&nbsp; Here's my situation.</P><P></P><P>We have facts at the country level (population, sq miles, etc).&nbsp; We also have facts at the customer level (sale, profit, trans. date).</P><P>Customer is in a country but a country may not have customers.</P><P></P><P>If we select country(s), we should get both country facts and customer facts for that selection.</P></BODY></HTML> Thu, 09 Jun 2016 15:39:52 GMT https://community.qlik.com/t5/QlikView/Multiple-grains-facts/m-p/1164000#M379158 2016-06-09T15:39:52Z