Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Garbage after expression

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.

15 Replies
agni_gold
Specialist III
Specialist III
Author

In a straight table.

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
agni_gold
Specialist III
Specialist III
Author

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.

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
agni_gold
Specialist III
Specialist III
Author

Thanks , but still having same problem