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

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

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

Anyone please tell me

Regards,

Devi.

MK_QSL — Tue, 22 Jul 2014 07:57:30 GMT

You can use Rank Function instead of Dimension Limit

Tue, 22 Jul 2014 08:17:03 GMT

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