Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cliff_clayman
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
santiago_respane
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:

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,

5 Replies
qlikrajan
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.

vinieme12
Esteemed Contributor II

Re: Set Analysis in a Straight Table to limit results

Add Calculated dimension as

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

and then Check Suppress when value is Null

cliff_clayman
Contributor

Re: Set Analysis in a Straight Table to limit results

What would the expression be for the example I gave?

santiago_respane
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:

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,

qlikrajan
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.

Community Browser