topic Re: Expression help. in QlikView

Expression help.

Thu, 01 Oct 2015 13:40:04 GMT

Sum([Annual amt])

if([BLD]='Own',Sum([BLDH]),Sum([BLDL]))

I am getting memory allocation full when I use the above expression in bar chart.Am I doing anything wrong here ?

Thank you.

MK_QSL — Thu, 01 Oct 2015 14:03:03 GMT

Sum([Annual amt])

SUM(if([BLD]='Own',[BLDH],[BLDL]))

m_woolf — Thu, 01 Oct 2015 14:03:04 GMT

I would rewrite the denominator as:

SUM(if([BLD]='Own',[BLDH],[BLDL]))

Can this value ever be zero? As I'm sure you know, dividing by zero is a no-no.

Thu, 01 Oct 2015 14:13:25 GMT

Thank you Manish.