topic aggr gave fail using filtering in QlikView https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555458#M207447 <HTML><HEAD></HEAD><BODY><P>Hi Qlikview guys,</P><P>I need you help again. Please look at Shift_Index_test.qvw file. I have two columns Shift and Index. The purpose of Index expression is to get the common sum by variable code . Index represents the similar logic as Shift but only calculates common sum . It work's good without DateShort filtering. If I choose filter on&nbsp; '2013.06'&nbsp; some values of&nbsp; 1205, 3001, 9003, 9020, 9021&nbsp; codes aren't represented. Could you please me explain what is matter? May be exists some possobilities to use shift code and calculate needed sum in another way without aggr. Thank you very much for any help.</P></BODY></HTML> Tue, 09 Jul 2013 10:54:54 GMT 2013-07-09T10:54:54Z aggr gave fail using filtering https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555458#M207447 <HTML><HEAD></HEAD><BODY><P>Hi Qlikview guys,</P><P>I need you help again. Please look at Shift_Index_test.qvw file. I have two columns Shift and Index. The purpose of Index expression is to get the common sum by variable code . Index represents the similar logic as Shift but only calculates common sum . It work's good without DateShort filtering. If I choose filter on&nbsp; '2013.06'&nbsp; some values of&nbsp; 1205, 3001, 9003, 9020, 9021&nbsp; codes aren't represented. Could you please me explain what is matter? May be exists some possobilities to use shift code and calculate needed sum in another way without aggr. Thank you very much for any help.</P></BODY></HTML> Tue, 09 Jul 2013 10:54:54 GMT https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555458#M207447 2013-07-09T10:54:54Z Re: aggr gave fail using filtering https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555459#M207448 <HTML><HEAD></HEAD><BODY><P>Your expression divides by zero for those 'missing' values.</P></BODY></HTML> Tue, 09 Jul 2013 11:07:56 GMT https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555459#M207448 Gysbert_Wassenaar 2013-07-09T11:07:56Z Re: aggr gave fail using filtering https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555460#M207449 <HTML><HEAD></HEAD><BODY><P>But the same code of Shift returns values.</P></BODY></HTML> Tue, 09 Jul 2013 11:14:11 GMT https://community.qlik.com/t5/QlikView/aggr-gave-fail-using-filtering/m-p/555460#M207449 2013-07-09T11:14:11Z