topic special aggregation functions in QlikView

special aggregation functions

Anonymous — Thu, 03 Apr 2014 08:27:06 GMT

I require a special aggregation function, please help -

My data looks like:

Customer SalesValue CreditLimit

111 100 50

111 200 50

222 500 100

I have a Pivot table and I want to create and expression for total Credit Limit in Customer Level, which should look like

Customer Sum of CreditLimit

total 150

111 50

222 100

I tried to do:

Aggr(sum(CreditLimit), Customer)

When I show the Customer Dimension in the Pivot table - everything is fine.

But, when I collapse the Customer dimension - the expression column becomes empty...

BTW - I cannot change the data structure...

Please help ...

Thanks

Yaniv

MK_QSL — Thu, 03 Apr 2014 08:31:06 GMT

Only(CreditLimit)

Aggr(Only(CreditLimit),Customer)

SUM(DISTINCT CreditLimit)

Aggr(SUM(DISTINCT CreditLimit),Customer)

Anonymous — Thu, 03 Apr 2014 08:41:00 GMT

I took a wild guess and tried:

sum(Aggr(sum(CreditLimit), Customer))

it worked

Thanks

Yaniv

MK_QSL — Thu, 03 Apr 2014 08:43:14 GMT

Have you tried any of my above suggestions?

I think all will work !

MK_QSL — Thu, 03 Apr 2014 08:45:18 GMT

Recheck.... your one is not working !!

Anonymous — Thu, 03 Apr 2014 10:58:22 GMT

Just did... works ok...

arjunkrishnan — Thu, 03 Apr 2014 11:03:16 GMT

=aggr(NODISTINCT Sum(CreditLimit),Customer)