Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a straight table with 3 fields. They are: Name, MLimit, TLimit. I only want to return the Names that have a MLimit value over 5000 AND a TLimit value of 1000. How can I write an expression for Name to return the values I would like to see?
Go to Solution.
if you want to solve it in a chart with set analysis you can do like this:
Add this expression:
This will filter all the names based on the set analysis but it will ignore the selections made that interferes with it.
If you want to solve it as a calculated dimension (qlikrajan's solution):
=IF(MLimit > 5000 and TLimit = 100, Name)
Please let me know if this helps.
you can put condition in dimension. For that you need to create calculated dimension. Click on add calculated dimension button.
Add Calculated dimension as
if(MLimit >5000 and TLimit=1000,Name)
and then Check Suppress when value is Null
What would the expression be for the example I gave?
in expression just mention the name of the fields. for example TLimit. it will give you the desired result. let me know if you want me to create a sample.