Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Re: Re: Re: Doubles in Pivot tables

Check if it is correct now and let me know.

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

regards

Darek

7 Replies
Not applicable

Re: Doubles in Pivot tables

Hi,

please attach application with sample data.

regards

Darek

Not applicable

Re: Re: Doubles in Pivot tables

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

Re: Re: Doubles in Pivot tables

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

Re: Re: Doubles in Pivot tables

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

Re: Re: Re: Doubles in Pivot tables

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

Re: Re: Re: Re: Doubles in Pivot tables

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

Re: Doubles in Pivot tables

THANKS A LOT!! YOU made my day.

Looks like this now in the real application.

PivotSolution.PNG.png

Best Regards

// Fjalar