Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Your expression divides by zero for those 'missing' values.
But the same code of Shift returns values.