# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor

## Sum, aggr and total

Hi everyone!

I have the next data:

type  transactions  client      type2

1           3              name1     123

2           4              name2     234

3          11              name3     345

1           4               name4    133

......

There are a lot of types.

I create a pivot table with the dimension type and, for each one, i created a calculated dimension:

=IF(

aggr(

rank(

SUM(

{<

type2 = {'1*'}

>}

transactions

)

),type, client) <= 10,

client)

this bring to me the top ten client with the maximun transactions (in the expression I sum the transactions where type2 = {'1*'})

This is ok, but, i need another expression that sum all the transactions grouped by type (for the example data for the type 1 the sum is 7), i try with aggr, sum and total but it doesnt work.

Thanks a lot!!

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: Sum, aggr and total

May be this:

Aggr(NODISTINCT Sum({<type2 = {'1*'}>} transactions), type)

10 Replies
MVP

## Re: Sum, aggr and total

What is the expected O/P from given table

Highlighted
Contributor

## Re: Sum, aggr and total

TYPE   TOTAL TRX

1               7

2               0

3               0

Honored Contributor

## Re: Sum, aggr and total

Hi Juan,

Have you tried

Sum(TOTAL <type> transactions) ?

EDIT :Sum({\$<type2 = {'1*'}>}TOTAL <type> transactions)

Kind regards

Andrew

Contributor

## Re: Sum, aggr and total

It give me back the total for each client, not for each type

Contributor

It doesnt work

MVP

## Re: Sum, aggr and total

I would have assumed effinty2112‌'s expression to have worked, would you be able to provide a sample to show where it isn't working for you?

Valued Contributor

## Re: Sum, aggr and total

AGGR(Sum({\$<type2 = {'1*'}>}TOTAL transactions),Type)

Contributor

## Re: Sum, aggr and total

it dosnt work, i need it in every row

MVP

## Re: Sum, aggr and total

May be this:

Aggr(NODISTINCT Sum({<type2 = {'1*'}>} transactions), type)