topic Need help in data modelling for tables at different granularities in App Development https://community.qlik.com/t5/App-Development/Need-help-in-data-modelling-for-tables-at-different/m-p/45145#M3035 <HTML><HEAD></HEAD><BODY><P>I have 3 tables (T1, T2, T3) for Actual's and 2 tables (T4, T5) for Plan related data. Out of these 5 tables T1, T3, T4 are all at same granularity (Product level) and almost have same dimensions and measures, where as tables T2 and T5 are at different granularity (Entity level) than the remaining 3 tables but have almost similar dimensions and measures (2 additional measures).</P><P></P><P>I concatenated all the 5 tables (Link table concept is not allowed unless &amp; until if there is no work around) and able to achieve all the requirements except while generating a chart where the calculation is something like</P><P>Sum( {&lt;Metric={'XYZ'},Product={'ABC'}&gt;}MTD_Actual) from T3/ Sum( {&lt;Metric={'ABC'}MTD_Actual) from T2</P><P></P><P>Please let me know if the data model approach is correct and how can we handle the above calculation as the values are at different levels.</P></BODY></HTML> Sun, 18 Mar 2018 21:30:53 GMT spavan1980 2018-03-18T21:30:53Z Need help in data modelling for tables at different granularities https://community.qlik.com/t5/App-Development/Need-help-in-data-modelling-for-tables-at-different/m-p/45145#M3035 <HTML><HEAD></HEAD><BODY><P>I have 3 tables (T1, T2, T3) for Actual's and 2 tables (T4, T5) for Plan related data. Out of these 5 tables T1, T3, T4 are all at same granularity (Product level) and almost have same dimensions and measures, where as tables T2 and T5 are at different granularity (Entity level) than the remaining 3 tables but have almost similar dimensions and measures (2 additional measures).</P><P></P><P>I concatenated all the 5 tables (Link table concept is not allowed unless &amp; until if there is no work around) and able to achieve all the requirements except while generating a chart where the calculation is something like</P><P>Sum( {&lt;Metric={'XYZ'},Product={'ABC'}&gt;}MTD_Actual) from T3/ Sum( {&lt;Metric={'ABC'}MTD_Actual) from T2</P><P></P><P>Please let me know if the data model approach is correct and how can we handle the above calculation as the values are at different levels.</P></BODY></HTML> Sun, 18 Mar 2018 21:30:53 GMT https://community.qlik.com/t5/App-Development/Need-help-in-data-modelling-for-tables-at-different/m-p/45145#M3035 spavan1980 2018-03-18T21:30:53Z Re: Need help in data modelling for tables at different granularities https://community.qlik.com/t5/App-Development/Need-help-in-data-modelling-for-tables-at-different/m-p/45146#M3036 <HTML><HEAD></HEAD><BODY><P>Maybe use <A href="https://community.qlik.com/docs/DOC-3451">Generic keys</A> as per this blog post by HIC.</P></BODY></HTML> Sun, 18 Mar 2018 21:53:52 GMT https://community.qlik.com/t5/App-Development/Need-help-in-data-modelling-for-tables-at-different/m-p/45146#M3036 Anonymous 2018-03-18T21:53:52Z