topic Re: Nothing selected - Correct; Something selected wrong in QlikView https://community.qlik.com/t5/QlikView/Nothing-selected-Correct-Something-selected-wrong/m-p/829702#M988358 <HTML><HEAD></HEAD><BODY><P>Try this (without {1} in the denominator)</P><P></P><P><STRONG>=Num(Aggr(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '#.##%')</STRONG></P></BODY></HTML> Mon, 20 Jul 2015 12:52:15 GMT sunny_talwar 2015-07-20T12:52:15Z Nothing selected - Correct; Something selected wrong https://community.qlik.com/t5/QlikView/Nothing-selected-Correct-Something-selected-wrong/m-p/829701#M988357 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I've attached a scorecard I am working on.</P><P>When there is no date selected (no year or quarter), the correct results for Index appear as correct as if I had 2014 q4 selected.</P><P>But when I select the year as 2014 Q4, then the Index row is incorrect. Needless to say, 2015 Q1 and Q2 are incorrect when I select them also. They should be in or around the 50% 20% 30% mark.</P><P>I've attached the qvw for a better understanding.</P><P></P><P>I've only 2014 Q4, 2015 Q1 and 2015 Q2 data so everything else will be empty</P><P></P><P>Can anyone see why when no year or quarter is selected, the actual 2014 Q4 data appears but then when I actually select the 2014 Q4, the incorrect data appears?</P><P></P><P>Any help appreciated.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Nothing-selected-Correct-Something-selected-wrong/m-p/829701#M988357 bobbydave 2020-11-20T18:02:30Z Re: Nothing selected - Correct; Something selected wrong https://community.qlik.com/t5/QlikView/Nothing-selected-Correct-Something-selected-wrong/m-p/829702#M988358 <HTML><HEAD></HEAD><BODY><P>Try this (without {1} in the denominator)</P><P></P><P><STRONG>=Num(Aggr(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '#.##%')</STRONG></P></BODY></HTML> Mon, 20 Jul 2015 12:52:15 GMT https://community.qlik.com/t5/QlikView/Nothing-selected-Correct-Something-selected-wrong/m-p/829702#M988358 sunny_talwar 2015-07-20T12:52:15Z