Mix dimensions in a single table

[Anonymous]

Hi qlikviewers,

I am stuck in something that I am not sure is possible to do...

I have a table with an id, a receiver, and the source. Sources and receivers are the same possible values. Ech receiver receives his own production (receiver=source) and imported production from the other sources. The general point of view is from the Receiver. However, I need to give also the Source point of view, in order to evaluate the % of own production, % import and % export.

I attach an example for better understanding. The question is: how to show this information in only one single table?

I will appreciate any help.

Thanks.

[Mattias_Malré]

Hi marc carreras

I moved your question over to the QlikView portion of the community.

Have a nice day

-Matt

[JonnyPoole]

i made an attempt based on your written explanation.  download the attached a look at the chart on the right. does it work ?

i'm using this to figure out the % of ids where receiver=source

sum(if(Receiver=Source,1,0))

/

count(DISTINCT id)

[jaimeaguilar]

Hi,

You can present a pivot table, showing a matrix between Sources and Receivers. Another option would be using a cyclic group.

Attached is the example,

regards

[Anonymous]

Hello Jaime Aguilar and @jpe and thanks fo your answers.

As you saw, it is very simple to get a table, pivot or not, with totals, import and %import. The key i was looking for was to show the export and % export within the same table.

My best approach was the pivot together the selector 'ProductionKind'. Now, if you select Import/Export the pivot table show the indicators about Import and Export, but not the owner one.

I know it seems simple, but i couldn't find out the solution... any idea?

Thanks again.