Dimensions and Expressions Tabs using Aggregate function Aggr() - QlikView Tutorial - Session 34
In this session you will learn about Dimensions and Expressions Tabs using Aggregate function Aggr()
Aggr()
--------
Similar to SQL Group By
Aggr(Exp,Dim1,Dim2,...)
Customer wise Grouping
-----------------------------------
Aggr(Sum(Sales),Customer)
Customer Salesman wise Grouping
-------------------------------------------------
Aggr(Sum(Sales),Customer,Salesman)
Examples
-------------
Displaying Top 5 Customers
Displaying Top Salesman foreach Customer
Displaying Top 5 Customers
---------------------------------------
Dimension Limits Tab
Dimensions Tab
Expressions Tab
Dimensions Tab
-----------------------
Perform Customer wise Grouping
Calculate Ranks
If Rank less_than_symbol=5, Display Customer
Go to Dimensions Tab - Select Dimension - Edit -
If(Aggr(Rank(Sum(Sales)),Customer) less_than_symbol=5,Customer)
Expressions Tab
----------------------
If(Aggr(Rank(Sum(Sales)),Customer)less_than_symbol=5,Sum(Sales))
Displaying Top Salesman for Each Customer
--------------------------------------------------------------
Dimensions Tab
----------------------
Perform Customer Salesman wise Grouping
Calculate Ranks
If Rank=1, Dsiplay Salesman
If(Aggr(Rank(Sum(Sales)),Customer,Salesman)=1,Salesman)
Expressions Tab
------------------------
If(Aggr(Rank(Sum(Sales)),Customer,Salesman)=1,Sum(Sales))
En esta página del sitio puede ver el video en línea Dimensions and Expressions Tabs using Aggregate function Aggr() - QlikView Tutorial - Session 34 de Duración hora minuto segunda en buena calidad , que subió el usuario In Music Vibes 03 enero 2019, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 574 veces y le gustó 2 a los espectadores. Disfruta viendo!
