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: 
RickyLam
Contributor III
Contributor III

Error in expression: Error in referenced measure

Hi all,

I am new to Qlik Sense, and I am facing a mysterious problem:

I created a master measure:

Name: xyz

Expression: =0

Then in a KPI, if I directly add "xyz" into it, the value 0 would be displayed as expected.

RickyLam_1-1688465623219.png

 

 

However, if I indirectly place it using the expression editor, I would receive the captioned error:

RickyLam_0-1688465474220.png

In fact, the error stays the same if the master measure is renamed using whatever names. And I am sure "xyz" is never referred in other measures. 

How do I troubleshoot it? Please advise. 

 

Labels (2)
1 Solution

Accepted Solutions
RickyLam
Contributor III
Contributor III
Author

Dear all,

Thanks for all of your quick reply and suggestions. By the way, I have just figured out the cause of the problem.

In fact, I didn't tell you that, in the definition of the master measure, besides the expression "=0", a comment line also precede it like this:

RickyLam_0-1688482520864.png

RickyLam_1-1688482549237.png

The expression is preceded by a comment and the expression itself begins with an equal sign....

After the comment line was removed, the problem disappeared when the measure is used as a part of the measure of a visualisation:

RickyLam_2-1688482748902.png

Thanks for all of your help and suggestions. Every suggestions of you give me valuable insights for me to sort out the problem by myself. Just I cannot help wondering how come Qlik Sense didn't give a more meaningful error message.... 

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What is the content of the xyz measure?

-Rob

udit_k
Partner - Creator II
Partner - Creator II

Use a variable as below :-

udit_k_0-1688481354918.png

Then create master measure using this variable

udit_k_5-1688481514571.png

Then using this master measure it doesn't show  any error

udit_k_2-1688481430766.png

udit_k_4-1688481475662.png

 

 

 

RickyLam
Contributor III
Contributor III
Author

Dear all,

Thanks for all of your quick reply and suggestions. By the way, I have just figured out the cause of the problem.

In fact, I didn't tell you that, in the definition of the master measure, besides the expression "=0", a comment line also precede it like this:

RickyLam_0-1688482520864.png

RickyLam_1-1688482549237.png

The expression is preceded by a comment and the expression itself begins with an equal sign....

After the comment line was removed, the problem disappeared when the measure is used as a part of the measure of a visualisation:

RickyLam_2-1688482748902.png

Thanks for all of your help and suggestions. Every suggestions of you give me valuable insights for me to sort out the problem by myself. Just I cannot help wondering how come Qlik Sense didn't give a more meaningful error message....