topic Re: Set Analysis: divide by zero in QlikView

Set Analysis: divide by zero

Tue, 26 Jan 2016 13:42:20 GMT

Hi all,

How can I do because VAR% in the attached example the column on the line agent A4 appears "-100.00"

This agent A4 not have sales in year 2015 and so the VAR column can not do with a division by 0.

(1 - sum (Year2014) / sum (Year2015)) * 100

For the line A4 is sum (Year2015) = 0

thank All

sunny_talwar — Tue, 26 Jan 2016 13:48:13 GMT

Try this:

Alt((1 - (Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /

Sum ({<Year={"$(=(max(Year)-0))"}>} Sales)) ) * 100, -100)

swuehl — Tue, 26 Jan 2016 13:50:16 GMT

Try

(1 - alt((Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /

Sum ({<Year={"$(=(max(Year)-0))"}>} Sales)) ,2)) * 100