topic Re: Expression not returning a value. in QlikView

Expression not returning a value.

rob_insley — Fri, 03 Oct 2014 10:15:56 GMT

I have a chart that contains the following expresisions

PO Lines = sum (POHeader.Count)

Catolog Lines = COUNT({$<[REQLine.CatalogType]={"CATALOG","NON-IPROC","EXTERNAL"}>}[REQLine.CatalogType])

%Lines Automated = COUNT({$<[REQLine.CatalogType]={"CATALOG","NON-IPROC","EXTERNAL"}>}[REQLine.CatalogType])/sum (POHeader.Count)

IT is not clear to see from the uploaded image but the % Lines are all correct . However when I remove PO Lines and CAtaolg Lines functions, the % Lines Automated Expression no longer provides a value for records that have 0 catalog Lines. Can anyone shed any light on this behaviour?

Please note I have blanked out the Org Name Values for Confidentiality,

Thanks,

Re: Expression not returning a value.

rubenmarin — Fri, 03 Oct 2014 10:22:00 GMT

Hi Rob, in presentation tab, try uncheck 'Supress zero values'.

When you have the expressions it's drawing the row beacuse there is at least one expression not equal to 0, when you left only the percentage, all rows that returns 0 are supressed.

Re: Expression not returning a value.

Gysbert_Wassenaar — Fri, 03 Oct 2014 10:22:30 GMT

Try disabling the Suppress Zero-Values option on the Presentation tab.

Re: Expression not returning a value.

rob_insley — Fri, 03 Oct 2014 10:40:31 GMT

Thanks both, I must master the myriad of presentation options. I