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: 
Anonymous
Not applicable

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

7 Replies
NZFei
Partner - Specialist
Partner - Specialist

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

Anonymous
Not applicable
Author

Hi Fei Xu,

The error is still showing

FCR title.JPG

still showing.JPG

NZFei
Partner - Specialist
Partner - Specialist

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

Anonymous
Not applicable
Author

screenshot expression.JPG

NZFei
Partner - Specialist
Partner - Specialist

Can you please show us the full screen like this?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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". Please LIKE threads if the provided solution is helpful to the problem.
Anonymous
Not applicable
Author

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