Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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....