# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor

## Set Analysis in a Straight Table to limit results

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?

1 Solution

Accepted Solutions
Valued Contributor

## Re: Set Analysis in a Straight Table to limit results

Hi Cliff,

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

=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,

5 Replies
Contributor III

## Re: Set Analysis in a Straight Table to limit results

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

Esteemed Contributor II

## Re: Set Analysis in a Straight Table to limit results

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

and then Check Suppress when value is Null

Contributor

## Re: Set Analysis in a Straight Table to limit results

What would the expression be for the example I gave?

Valued Contributor

## Re: Set Analysis in a Straight Table to limit results

Hi Cliff,

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

=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,

Contributor III

## Re: Set Analysis in a Straight Table to limit results

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.