topic Re: Help with Trellis Chart in QlikView

Help with Trellis Chart

pkelly — Wed, 13 Jul 2011 09:53:32 GMT

Hi all...

I am working on an aged debt report and have the following fields...

cur_Code - Debt Currency (GBP, EUR etc)

agd_InvoiceBreak - Aged Days (01-30, 31-60, 61-90 etc).

agd_RemainingAmount - Remaining Amount

I have created a Trellis chart with cur_Code and agd_InvoiceBreak as my dimensions and sum(agd_RemainingAmount) as my expression.

What I want to see is the % split by currency for each of the Aged Days (agd_InvoiceBreak).

So each trellis chart in total would come to 100% split along the Aged Days.

What I am getting is the three currency charts coming to 100% in total - hope that makes sense!

I have tried playing about with my formula using the aggr function but have had no success.

Any help greatly appreciated...

Regards

Paul

lironbaram — Wed, 13 Jul 2011 10:19:49 GMT

hei paul

try this example

i changed the expression

hope its helps you

pkelly — Wed, 13 Jul 2011 10:38:44 GMT

Thanks RoiUser...

=sum(agd_RemainingAmount)/sum(TOTAL <cur_Code>agd_RemainingAmount)

Would never have got this - had been trying...

=sum(agd_RemainingAmount) / aggr(sum(TOTAL agd_RemainingAmount), cur_Code)

Many Thanks

Paul