Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
AdrianoEllero
Contributor III
Contributor III

syntax error in Calculation condition expression

Aiming to filter some measures and use extend it to the entire table, I have tried to use this condition:

{<Material={"xyz"}>}

in the Calculation condition field:

 

AdrianoEllero_0-1710940312484.png

I get syntax error.

Any hint how to solve it or some way to do it properly?

Labels (5)
2 Replies
ElisaF
Contributor III
Contributor III

Hello,

"Calculation Condition" option is used to determine whether or not an object (e.g. chart) is to be displayed.

If this is the requirement, try the formula: IF(Match(Material,'xyz'),1,0)=0 If the end-user selects the material with code xyz, he chart will be "hidden", as in the image below.

ElisaF_0-1710942604653.png

You can also try other formulas, depending on the other conditions / requirements / data mart of the application. See the response in the link below.

https://community.qlik.com/t5/QlikView-App-Dev/Calculation-Condition-for-a-chart/td-p/366076

Additionally, the message displayed upon meeting the condition can be customized.

Nicolae_Alecu
Creator
Creator

Hello, 

My understanding is that you have a measure with set analysis {<Material={"xyz"}>} and you want to display only these lines that match the condition.

In this case, all other lines should be "0" and you can uncheck "Include 0 values".

Best regards,