Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
However, if I indirectly place it using the expression editor, I would receive the captioned error:
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.
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:
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:
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....
What is the content of the xyz measure?
-Rob
Use a variable as below :-
Then create master measure using this variable
Then using this master measure it doesn't show any error
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:
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:
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....