topic Re: Re: Re: Re: Doubles in Pivot tables in QlikView

Doubles in Pivot tables

Sun, 13 Apr 2014 20:12:30 GMT

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]

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

Re: Doubles in Pivot tables

Sun, 13 Apr 2014 22:36:24 GMT

Hi,

please attach application with sample data.

regards

Darek

Re: Re: Doubles in Pivot tables

Mon, 14 Apr 2014 09:46:06 GMT

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.

Re: Re: Doubles in Pivot tables

Mon, 14 Apr 2014 10:09:06 GMT

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

Re: Re: Doubles in Pivot tables

Mon, 14 Apr 2014 10:14:36 GMT

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

Re: Re: Re: Doubles in Pivot tables

Mon, 14 Apr 2014 10:45:26 GMT

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

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

Mon, 14 Apr 2014 11:07:40 GMT

Check if it is correct now and let me know.

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

regards

Darek

Re: Doubles in Pivot tables

Mon, 14 Apr 2014 11:30:36 GMT

THANKS A LOT!! YOU made my day.

Looks like this now in the real application.

Best Regards

// Fjalar