Garbage after expression

[agni_gold]

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.

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[vinieme12]

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?

[agni_gold]

No , my dimension is only month field.

[agni_gold]

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.

[vinieme12]

the expression that gives the error, can you post ?

[agni_gold]

=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))

[vinieme12]

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

[agni_gold]

sorry it is not working

[vinieme12]

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