Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zhbuyiqlik
New Contributor

Error: Garbage after expression

I created a pivot table that displays sales across different dimension.  I wanted to put the total sales on top of the sheet.  So I created a measure called Total Sales=Sum(Sales) and threw on to the top of the sheet.   The total is correct as I checked and it changes in response to all kinds of filtering.  But there is a message saying "Error: Garbage Over Expression" on the total Box. 

Don't know why.

Thanks

Message was edited by: Buyi Zhang

13 Replies
dwforest
Valued Contributor

Re: Error: Garbage after expression

Any row of data not have a numeric value for Sales?

Highlighted
zhbuyiqlik
New Contributor

Re: Error: Garbage after expression

No, they are all numeric.

thiago_justen
Valued Contributor III

Re: Error: Garbage after expression

Make sure your Sales data is numeric. You can also try something like this:

Sum(Num#(Sales))

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: Error: Garbage after expression

Could you please take a snapshot of the screen with expression?

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago

Re: Error: Garbage after expression

Screenshot please?

zhbuyiqlik
New Contributor

Re: Error: Garbage after expression

This did not work

zhbuyiqlik
New Contributor

Re: Error: Garbage after expression

Top right corner

Qlik Sum.png

zhbuyiqlik
New Contributor

Re: Error: Garbage after expression

Top right corner.  Thanks

Qlik Sum.png

walidhussein
Contributor

Re: Error: Garbage after expression

If you are trying to start with a text concatenated with an expression you need to have it in this format:

="Total Sales = "&Sum(Sales)

That might fix the expression!

Community Browser