Set Analysis in a Straight Table to limit results

[cliff_clayman]

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?

[Anonymous]

you can put condition in dimension. For that you need to create calculated dimension. Click on add calculated dimension button.

[vinieme12]

Add Calculated dimension as

if(MLimit >5000 and TLimit=1000,Name)

and then Check Suppress when value is Null

[cliff_clayman]

What would the expression be for the example I gave?

[santiago_respane · Accepted solution]

Hi Cliff,

if you want to solve it in a chart with set analysis you can do like this:

Add this expression:

=SUM({<MLimit={">5000"},TLimit={1000}>} 1)

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.

Kind regards,

[Anonymous]

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.