Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Gysbert_Wassenaar

Please post a small qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
vinieme12
Champion III
Champion III

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?

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

No , my dimension is only month field.

agni_gold
Specialist III
Specialist III
Author

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
Champion III
Champion III

the expression that gives the error, can you post ?

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

=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
Champion III
Champion III

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

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

sorry it is not working

vinieme12
Champion III
Champion III

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

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