Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

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
Specialist
Specialist

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,

View solution in original post

5 Replies
Anonymous
Not applicable

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

vinieme12
Champion III
Champion III

Add Calculated dimension as

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

and then Check Suppress when value is Null

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
cliff_clayman
Creator II
Creator II
Author

What would the expression be for the example I gave?

santiago_respane
Specialist
Specialist

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
Not applicable

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.