Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly
Specialist
Specialist

Help with Trellis Chart

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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei paul

try this example

i changed the expression

hope its helps you

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei paul

try this example

i changed the expression

hope its helps you

pkelly
Specialist
Specialist
Author

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