topic Script calculations or Set analysis? in QlikView https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710975#M256092 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to know, as a best practice, which methodology is better?</P><P>to do all possible calculations in the script and create more calculated data tables in memory, or, </P><P>do the calculations using set analysis?</P><P></P><P>what are the trade-offs?</P><P></P><P></P><P>Thanks,</P><P></P><P>Boris </P></BODY></HTML> Sun, 28 Sep 2014 07:04:48 GMT 2014-09-28T07:04:48Z Script calculations or Set analysis? https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710975#M256092 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to know, as a best practice, which methodology is better?</P><P>to do all possible calculations in the script and create more calculated data tables in memory, or, </P><P>do the calculations using set analysis?</P><P></P><P>what are the trade-offs?</P><P></P><P></P><P>Thanks,</P><P></P><P>Boris </P></BODY></HTML> Sun, 28 Sep 2014 07:04:48 GMT https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710975#M256092 2014-09-28T07:04:48Z Re: Script calculations or Set analysis? https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710976#M256093 <HTML><HEAD></HEAD><BODY><P>Try to create good data model for the application and follow one of the data modelling techniques like</P><P>Star Schema or Snowflake Schema, best is Star Schema.</P><P></P><P>Regards</P></BODY></HTML> Sun, 28 Sep 2014 07:12:53 GMT https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710976#M256093 its_anandrjs 2014-09-28T07:12:53Z Re: Script calculations or Set analysis? https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710977#M256094 <HTML><HEAD></HEAD><BODY><P>I am using a star schema, but still I have to use a lot of set analysis due to complex charts I need to calculate.</P><P></P><P>my questions is in terms of performance, what are the trade-offs in building more calculated tables in memory or doing the calculations in the set analysis? </P></BODY></HTML> Sun, 28 Sep 2014 07:16:07 GMT https://community.qlik.com/t5/QlikView/Script-calculations-or-Set-analysis/m-p/710977#M256094 2014-09-28T07:16:07Z