Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

fasuhaibani
New Contributor III

How to Use a Measure Result As Dimension?

Hello Everyone!

I was wondering if I can use a measure result condition as a Dimension (i.e. assuming I have measure X which is the avg time, I'd like to have a dimension like the following: X < 20, X=20 , X>20)

Your help is really appreciated!

1 Solution

Accepted Solutions

Re: How to Use a Measure Result As Dimension?

A measure is calculated over dimension values. If used without dimensions then a measure returns only one value.

So if you want to use a measure as a dimension you probably want to use the measure values calculated for each of the dimension values of a dimension. So you need to use the aggr function to build a virtual table with the list of measures per dimension value.

Something like this:

Aggr(

     If( avg(Time) < 20, 'X<20',

          If( avg(Time)=20,'X=20','X>20'))

     DimensionA, DimensionB, ...etc )


talk is cheap, supply exceeds demand
1 Reply

Re: How to Use a Measure Result As Dimension?

A measure is calculated over dimension values. If used without dimensions then a measure returns only one value.

So if you want to use a measure as a dimension you probably want to use the measure values calculated for each of the dimension values of a dimension. So you need to use the aggr function to build a virtual table with the list of measures per dimension value.

Something like this:

Aggr(

     If( avg(Time) < 20, 'X<20',

          If( avg(Time)=20,'X=20','X>20'))

     DimensionA, DimensionB, ...etc )


talk is cheap, supply exceeds demand
Community Browser