Discussion Board for collaboration on QlikView Scripting.
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.
Solved! Go to Solution.
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.
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.
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.