topic Mix dimensions in a single table in QlikView

Mix dimensions in a single table

Anonymous — Tue, 05 Aug 2014 12:34:24 GMT

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.

Re: Mix dimensions in a single table

Mattias_Malré — Tue, 05 Aug 2014 13:02:06 GMT

Hi marc carreras

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

Have a nice day

-Matt

Re: Re: Mix dimensions in a single table

JonnyPoole — Tue, 05 Aug 2014 16:04:25 GMT

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)

Re: Mix dimensions in a single table

jaimeaguilar — Tue, 05 Aug 2014 17:11:12 GMT

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

Re: Mix dimensions in a single table

Anonymous — Wed, 06 Aug 2014 07:02:32 GMT

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.