Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr gave fail using filtering

Hi Qlikview guys,

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  '2013.06'  some values of  1205, 3001, 9003, 9020, 9021  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.

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Your expression divides by zero for those 'missing' values.


talk is cheap, supply exceeds demand
Not applicable
Author

But the same code of Shift returns values.