topic Re: Garbage after expression in QlikView

Garbage after expression

agni_gold — Sat, 16 Jul 2016 12:53:50 GMT

Hi Friends,

I am getting Garbage after expression error message coming in my report like below ,when i am exporting report , while in dashboard no error is coming everything working fine.

Garbage after expression 209

or in some case

Garbage after expression 4F39578F

please suggest why i am getting this error and how to correct this.

Re: Garbage after expression

Gysbert_Wassenaar — Sat, 16 Jul 2016 13:37:56 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 13:46:41 GMT

Can you post your expression? and confirm the dimensions you have in your chart, are you using any aggregated dimension in your expression or concat?

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 13:58:08 GMT

No , my dimension is only month field.

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 14:00:33 GMT

Hi Gysbert ,

Actually i am using Nprinting On demand extension to generate PPT report , when i generates my report in PPT above error message coming. While in dashboard every thing working fine.

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 14:05:27 GMT

the expression that gives the error, can you post ?

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 14:12:08 GMT

=if(sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)=0 or

sum({$<Month=,ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE)=0,' ',

sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)-sum({$<Month=,

ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE))

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 14:21:09 GMT

if(sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)=0 or

sum({$<Month=,ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE)=0,chr(32),

sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)-sum({$<Month=,

ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE))

Try the above instead

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 14:24:14 GMT

sorry it is not working

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 14:33:42 GMT

where exactly are you using this expression>\? chart / text object, header??

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 14:35:22 GMT

In a straight table.

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 14:36:16 GMT

Or this

if(sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)>0 or

sum({$<Month=,ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE)>0,

sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)-sum({$<Month=,

ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE), null() )

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 14:42:00 GMT

what happens if instead of space you put a Zero? and then change Text format expression to match cell background if the value is Zero

if(sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)=0 or

sum({$<Month=,ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE)=0,0,

sum({$<Month=,ACTUALITY_CODE={'BU'}>}FIN__MARKETSHARE)-sum({$<Month=,

ACTUALITY_CODE={'AJ'}>}FIN__MARKETSHARE))

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 15:22:04 GMT

Hi Vineeth ,

Thanks , but my dashboard was already running correctly ,

Actually i am using Nprinting On demand extension to generate PPT report , when i generates my report in PPT above error message coming in PPT . While in dashboard every thing working fine.

Re: Garbage after expression

vinieme12 — Sat, 16 Jul 2016 16:15:05 GMT

Yes, i'm only suggesting a workaround to your problem

Re: Garbage after expression

agni_gold — Sat, 16 Jul 2016 18:03:36 GMT

Thanks , but still having same problem