Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubles in Pivot tables

Hi,

I have a little problem with a Pivot table.  I understand why this happens but not how I can solve this in some easy (or hard) way

The information in the Pivot table come from following tables:

Fact table:  [Innvoice No.], [Line Type], [Spl Country],[Receiver Country],[Order Type],[Inv Amount]

GenLedg  : [Account], [VAT Code], [GL Amount]

pivotDoubles.png'

I don’t need both [Inv Amount] and [GL Amount].

What can I do to get rid of the doubles? 

One Idea was to concatenate Spl Country to one string if there are two [Spl Country] but I’m not sure how I do that.

Would be very thankful if someone could help me or give me some good advice.

// Fjalar

1 Solution

Accepted Solutions
Not applicable
Author

Check if it is correct now and let me know.

Maybe there will be something more to do on expressions side.....

regards

Darek

View solution in original post

7 Replies
Not applicable
Author

Hi,

please attach application with sample data.

regards

Darek

Not applicable
Author

Hi,

I don't want to have the doubles.  If it is possible in some way to mark invoices that have doubles and/or concatenate supplier in one field.

Not applicable
Author

Fjalar,

i'am trying to find those "doubles", but i'am not sure where they are

You told:"I understand why this happens" .... So, please maybe export your chart to excel and then mark cells with this problem.

regards

Darek

Not applicable
Author

The best way for me to help you will be if you show me 2 things - how your chart looks now and how you want it to look. Having this difference it will be easier to find how to resolve it.

regards

DArek

Not applicable
Author

In sum(SalesValues) I get the totals for each country because those fields are in the same table but doubles for each Account (from another table)

In sum(GL_Amount) I get the totals for each Account because those fields are in the same table but doubles for each country ( from another table)

I think it would be nice if I could check it there are mote than one country in each invoice and in that case concatenate the values.

See attached file.  I have no idea if this is possible.

// Fjalar

Not applicable
Author

Check if it is correct now and let me know.

Maybe there will be something more to do on expressions side.....

regards

Darek

Not applicable
Author

THANKS A LOT!! YOU made my day.

Looks like this now in the real application.

PivotSolution.PNG.png

Best Regards

// Fjalar