topic Re: Set Analysis in a Straight Table to limit results in QlikView

Set Analysis in a Straight Table to limit results

cliff_clayman — Tue, 26 Jul 2016 18:42:35 GMT

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?

Re: Set Analysis in a Straight Table to limit results

Anonymous — Tue, 26 Jul 2016 18:47:01 GMT

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

Re: Set Analysis in a Straight Table to limit results

vinieme12 — Tue, 26 Jul 2016 18:49:19 GMT

Add Calculated dimension as

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

and then Check Suppress when value is Null

Re: Set Analysis in a Straight Table to limit results

cliff_clayman — Tue, 26 Jul 2016 18:49:37 GMT

What would the expression be for the example I gave?

Re: Set Analysis in a Straight Table to limit results

santiago_respane — Tue, 26 Jul 2016 18:54:51 GMT

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,

Re: Set Analysis in a Straight Table to limit results

Anonymous — Tue, 26 Jul 2016 18:55:22 GMT

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.