topic Re: Hi in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/486031#M555359 <HTML><HEAD></HEAD><BODY><P>Please read Henric's blog post </P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations">http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations</A></P><P></P><P>to understand why the expression returns NULL when there are two Allocated Resource values possible.</P><P></P><P>(Try an aggregation function like sum([Allocated Resource]) )</P><P></P><P>You might also want to review your data model, I think proper linking your tables should remove your need for the if() statement, as far as I've understood your current model).</P></BODY></HTML> Mon, 12 Aug 2013 17:00:52 GMT swuehl 2013-08-12T17:00:52Z Hi https://community.qlik.com/t5/QlikView/Hi/m-p/486030#M555351 <HTML><HEAD></HEAD><BODY><P>hi</P></BODY></HTML> Mon, 12 Aug 2013 16:50:19 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/486030#M555351 2013-08-12T16:50:19Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/486031#M555359 <HTML><HEAD></HEAD><BODY><P>Please read Henric's blog post </P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations">http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations</A></P><P></P><P>to understand why the expression returns NULL when there are two Allocated Resource values possible.</P><P></P><P>(Try an aggregation function like sum([Allocated Resource]) )</P><P></P><P>You might also want to review your data model, I think proper linking your tables should remove your need for the if() statement, as far as I've understood your current model).</P></BODY></HTML> Mon, 12 Aug 2013 17:00:52 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/486031#M555359 swuehl 2013-08-12T17:00:52Z