

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can put condition in dimension. For that you need to create calculated dimension. Click on add calculated dimension button.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add Calculated dimension as
if(MLimit >5000 and TLimit=1000,Name)
and then Check Suppress when value is Null
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What would the expression be for the example I gave?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
