topic Re: Pivoting/Straigh Table chart in QlikView

Pivoting/Straigh Table chart

Wed, 25 Nov 2020 16:16:04 GMT

I have the following excel where in group 1 there are 3 teams and group 2 has 3 teams. Each team has certain number of players. I want number of players to be aggregated at group level.Kindly help

Re: Pivoting/Straigh Table chart

Anonymous — Wed, 01 Jun 2016 09:19:26 GMT

Hi ,

In your Name Column , you hve null data .

Inorder to aggregate or group by , you should not have any blanks or nulls in the column which you'll use for grouping .

Re: Pivoting/Straigh Table chart

Colin-Albert — Wed, 01 Jun 2016 09:24:59 GMT

Remove Players from your chart dimensions.

Remove the Players>0 measure

Add Sum(Players) as a measure to your chart.

Re: Pivoting/Straigh Table chart

sunny_talwar — Wed, 01 Jun 2016 10:30:44 GMT

Is this what is needed?

Script changes (you might not need this)

LOAD If(Len(Trim(Name)) > 0, Name, Peek('Name')) as Name,

Teams,

Players

FROM

[test (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

Expression:

Sum(TOTAL <Name> Players)

Re: Pivoting/Straigh Table chart

Wed, 01 Jun 2016 18:20:05 GMT

Hi Sunny

As always, thanks for your prompt help. I implemented this in my PIVOT table. Now I want 60 and 150 the totals to be displayed only once and the Players column should not be displayed. Kindly help me as to how to achieve that

Re: Pivoting/Straigh Table chart

sunny_talwar — Wed, 01 Jun 2016 19:34:53 GMT

Like this?

Re: Pivoting/Straigh Table chart

Thu, 02 Jun 2016 14:06:38 GMT

Hi Sunny,

Thanks again for your response. I implemented it today at work with my tables and it is fine. Now the last help in this series, can I have group name and Team Name in the same column and the number aggr against each team at top, something like this

Group 1 60

Team 1 60

Team 2

Team 3

Group 2 150

Team 4 150

Team 5

Team 6

Is this possible? I have multiple levels and this is just an example of my application. I have to aggregate all children to it parent upto the root