WHat is calculated dimension in chart properties ?... - Qlik Community

nikhilgarg · ‎2014-09-17

Hey,

WHat is calculated dimension in chart properties ??

Please help.

Thaks.

MK_QSL · ‎2014-09-17

Calculated Dimension is a dynamically calculated field, which is derived from one or more fields.

Consider that you want to have only Customer from specific country i.e. Germany....

you can use

IF(Country = 'Germany', Customers)

as a Calculated Dimension..

More complex, if you want only top 5 customers...

you can use combination of SUM, Aggr, Rank to get the result..

IF(Aggr(Rank(SUM(Sales),4),Customer)<=5, Customer)

If you want to divide your sales in a group of 1000 and need to have customers falling in this group. ...

=Class(Aggr(SUM(Amount),Customer),1000)

and Expression = COUNT(Distinct Customer)

Hope this helps..