Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
I get syntax error.
Any hint how to solve it or some way to do it properly?
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.
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.
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,