Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression help.

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Sum([Annual amt])

/

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

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Sum([Annual amt])

/

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

m_woolf
Master II
Master II

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.



Not applicable
Author

Thank you Manish.