Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

In QV11 dimensionlimits are introduced.In previous versions which can be used instead of this?

Hi,

    Anyone please tell me

Regards,

Devi.

2 Replies
MK_QSL
MVP
MVP

You can use Rank Function instead of Dimension Limit

Not applicable
Author

Dear Devi,

Prior to QV 11 you calculate the dimension

You can calculate a dimension on the dimension tab, the following will give you the top 5 sales dimensions:

          Aggr(If(Rank(Sum(Sales))<5, 'Dim_Name', 'All Other Value'), Dim_Name)

Hope this helps, if you are still struggling please post a example. 

Regards

R