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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression is working fine in Table Chart but not in Line Chart

Hi All,

I have the following calculation working fine in Table Chart, but not in Line Chart.  Can you please let me know

=(

  if((if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1))=0,0, ((sum(e1) + sum(e2) + sum(e3)) / (if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1)))) +

  if((if(isnull(f1),0,1) + if(isnull(f2),0,1) + if(isnull(f4),0,1))=0,0, ((sum(f1) + sum(f2) + sum(f4)) / (if(isnull(f1),0,1) + if(isnull(f2),0,1) )))

)

/

(

if((if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1))=0,0,1) +

if((if(isnull(f1),0,1) + if(isnull(f2),0,1) + if(isnull(f4),0,1)) =0,0,1)

)

1 Reply
Anonymous
Not applicable
Author

Hey,

Can you provide qlikview document containing the not working line chart?