Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

shane_spencer
Valued Contributor

Set Analysis and Aggregation

gt.PNG

 

 

 

 

I've got a count of the number of Business Units and Companies (far right). What I want to do is aggregate these up by the VAT Number (far left). So for this example it should be 44 Business Companies on each row (instead of 40, 3 and 1). PFA the working example. Any help would be appreciated.

Labels (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis and Aggregation

Sound like you need a partial total. No need for set analysis or Aggr(). Something like:

Count(TOTAL <[VAT Number]> ......

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
MVP
MVP

Re: Set Analysis and Aggregation

Sound like you need a partial total. No need for set analysis or Aggr(). Something like:

Count(TOTAL <[VAT Number]> ......

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post