Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

williamfuu
Contributor II

Limit dimension in straight table

How can I limit the rows in a straight table based on the set analysis measure result?

e.g.: show rows only where the measure is between 80% and 100%

The built in limitation feature seems to only allow one condition.

I tried creating a calculated dimension with this condition, but it displays as invalid dimension on the table.

5 Replies
dwforest
Valued Contributor

Re: Limit dimension in straight table

Count({$<measure={">=.8<=1"}>} measure_id)

williamfuu
Contributor II

Re: Limit dimension in straight table

My measure is already a set analysis expression, not sure to pull this off in your example

dwforest
Valued Contributor

Re: Limit dimension in straight table

You can add as many fields to your set express within the aggregation; to be clear expression is not set expression.

what is the current value of your measure?

In this example:

    Count({$<measure={">=.8<=1"}>} measure_id)

this is the set expression

    {$<measure={">=.8<=1"}>}


https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set...

nizamsha
Valued Contributor

Re: Limit dimension in straight table

might be

= if(

Sum({$<Name={"*"}>}Amount) >=300 and Sum({$<Name={"*"}>}Amount) <=500,

Sum({$<Name={"*"}>}Amount))

its kind of hardcode

kaanerisen
Contributor III

Re: Limit dimension in straight table

You can try this,

sum(

     aggr(

               If(

                    SUM({<SetExpression>}measure)>=0.8 and SUM({<SetExpression>}measure)<=1,

                    SUM({<SetExpression>}measure)

                 )

               ,DimensionList

            )

       )

Community Browser