topic data modellling and changes at load script in QlikView https://community.qlik.com/t5/QlikView/data-modellling-and-changes-at-load-script/m-p/351810#M1174399 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i want to know what are the best practices when designing a data model for the qlik view and what logics should we implement at the back end instead of UI level.</P><P></P><P>for example i need to show a column 'provider' ranked and sorted on the basis of a measure amount...i need to show top 50 providers and then i have to perform calculations on another measure 'Pd_amnt'. i nee to show the sum of top50 providers,sum of pd_amnt for remining providers and total of aal as i different row??</P><P></P><P>how can i achieve that??/</P></BODY></HTML> Tue, 15 May 2012 08:55:54 GMT 2012-05-15T08:55:54Z data modellling and changes at load script https://community.qlik.com/t5/QlikView/data-modellling-and-changes-at-load-script/m-p/351810#M1174399 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i want to know what are the best practices when designing a data model for the qlik view and what logics should we implement at the back end instead of UI level.</P><P></P><P>for example i need to show a column 'provider' ranked and sorted on the basis of a measure amount...i need to show top 50 providers and then i have to perform calculations on another measure 'Pd_amnt'. i nee to show the sum of top50 providers,sum of pd_amnt for remining providers and total of aal as i different row??</P><P></P><P>how can i achieve that??/</P></BODY></HTML> Tue, 15 May 2012 08:55:54 GMT https://community.qlik.com/t5/QlikView/data-modellling-and-changes-at-load-script/m-p/351810#M1174399 2012-05-15T08:55:54Z