topic data model question in QlikView https://community.qlik.com/t5/QlikView/data-model-question/m-p/737577#M263754 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P>I'm facing following data model problem. I got essbase like numbers already aggregated on different levels (and they don't sum up). For example:</P><P>brand name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sku 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sku 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; </P><P> Challenge is how to model it in Qlik. When user choose brand name chart should show 100 value when sku 1 is selected value 5 should be shown. I tried to use generic exclusive generic keys, but the problem is when you choose brand name then Qlik sum values for brand name and skus. </P><P></P><P>I would be grateful for any hint </P><P></P><P>Regards.</P></BODY></HTML> Mon, 25 Aug 2014 13:59:48 GMT salezian 2014-08-25T13:59:48Z data model question https://community.qlik.com/t5/QlikView/data-model-question/m-p/737577#M263754 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P>I'm facing following data model problem. I got essbase like numbers already aggregated on different levels (and they don't sum up). For example:</P><P>brand name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sku 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sku 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; </P><P> Challenge is how to model it in Qlik. When user choose brand name chart should show 100 value when sku 1 is selected value 5 should be shown. I tried to use generic exclusive generic keys, but the problem is when you choose brand name then Qlik sum values for brand name and skus. </P><P></P><P>I would be grateful for any hint </P><P></P><P>Regards.</P></BODY></HTML> Mon, 25 Aug 2014 13:59:48 GMT https://community.qlik.com/t5/QlikView/data-model-question/m-p/737577#M263754 salezian 2014-08-25T13:59:48Z