Limit dimension in straight table

[william_fu]

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.

[dwforest]

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

[william_fu]

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

[dwforest]

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]

might be

= if(

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

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

its kind of hardcode

[kaanerisen]

You can try this,

sum(

     aggr(

               If(

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

                    SUM({<SetExpression>}measure)

                 )

               ,DimensionList

            )

       )