Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New Contributor III

Limitations Of Dimensions

Hello,

I Want to limit Number of dimensions Shown on charts. but I use Growth rate as measure, and  when I go to limitations and Fixed numbers, then it Limit it with growth rate  but I want to limit with volume of sales.How It is possible to show top 5 companies with the largest volume of Sales but as measure to have Growth rate?  

1 Solution

Accepted Solutions
MVP
MVP

Re: Limitations Of Dimensions

Something like

Sum(Aggr(If(Rank(Sum(-Sales)) <= 5, ... growth expression ...), Company))


Insert your expression for growth and adapt as required to your environment

2 Replies
MVP
MVP

Re: Limitations Of Dimensions

Something like

Sum(Aggr(If(Rank(Sum(-Sales)) <= 5, ... growth expression ...), Company))


Insert your expression for growth and adapt as required to your environment

mariamovasheli
New Contributor III

Re: Limitations Of Dimensions

It is exactly what I wanted Thank you very much

Community Browser