Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Grouping data in my pivottable

Hi Guys,

I have a question about the following:

I have this table with 100+ organizations and their data. What i would like is to show the top 30 performers and group the rest as 'other' which should be the sum of the last 70+ organizations.

I hope my question is clear and you guys can help me out.

(I am using a pivot table btw)

Thanks in advance.

3 Replies
lironbaram
Honored Contributor II

Re: Grouping data in my pivottable

hi you can do it using a calculated dimension

something like

aggr(if(rank(Sum(Sales)<=30,OrgName),OrgName)

Not applicable

Re: Grouping data in my pivottable

Hi,

This is a start, however when i use the rank function the table now shows the orgname, however i want to see the revenue from that organization.

Also this doesnt show a new 'grouped' row where i can see how much the other revenue is grouped together. Below you can see what happened.

QV voorbeeld.JPG

lironbaram
Honored Contributor II

Re: Grouping data in my pivottable

what i sent you should be used in the dimension with this change

aggr(if(rank(Sum(Sales)<=30,OrgName,'Other'),OrgName)

than in the expression you can use sum(revenue)

however the above method will display the top 30 performers in the whole time frame you are looking at

and not on a week by week basic 

Community Browser