Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

Error: Garbage Expression

anything wrong with my formula? Error Garbage Expression keeps on showing though the % result is correct.

count(aggr(if(Sum([Aggr nOffered])>1,num(Sum([Aggr nOffered]),vFormatSeconds2), null()) ,[Formatted CLI])) / count(distinct{<[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}>} [Formatted CLI])

Please help....

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Honored Contributor III

Re: Error: Garbage Expression

It is not your measure expression

In Master objects you might have dynamic name for your label and that is what is failing.

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
7 Replies
xufei123
Valued Contributor

Re: Error: Garbage Expression

That is the title. Make sure you have the correct title there (Maybe Repeat only):

eustisab
New Contributor III

Re: Error: Garbage Expression

Hi Fei Xu,

The error is still showing

FCR title.JPG

still showing.JPG

xufei123
Valued Contributor

Re: Error: Garbage Expression

I see, the title is correct. It is the expression. Can you show me the screenshot for the whole expression?

eustisab
New Contributor III

Re: Error: Garbage Expression

screenshot expression.JPG

xufei123
Valued Contributor

Re: Error: Garbage Expression

Can you please show us the full screen like this?

Lech_Miszkiewicz
Honored Contributor III

Re: Error: Garbage Expression

It is not your measure expression

In Master objects you might have dynamic name for your label and that is what is failing.

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
eustisab
New Contributor III

Re: Error: Garbage Expression

now i see that... Thanks Lech!!!

Community Browser