topic Re: 2 dimensions 1 election in QlikView

2 dimensions 1 election

Wed, 10 Jun 2015 12:34:05 GMT

I do not know if it is possible in QlikView as follows:

I have a pivot table with two dimensions which is for example:

SUBJECT

and the other:

RESULT

The subjects are:

and RESULTS:

approved

thriller

But there is another result2:

Approved and Suspense

I want you in the same table the subjects:

1,2 and 3 have RESULT

4 and 5 and have result2

But all on the same table as if it were the result and result2 same dimension.

All data subjects have result2 but result and just want a dimension to appear and take depending on the data subject or result2 RESULT.

Is this possible?

Thank you.

Re: 2 dimensions 1 election

sunny_talwar — Wed, 10 Jun 2015 12:36:22 GMT

Do you have a sample and expected output you can share? It would be much easier to understand your requirement looking at some data.

Best,

Sunny

Re: 2 dimensions 1 election

Kushal_Chawda — Wed, 10 Jun 2015 12:40:18 GMT

Can you please explain with example and desired output ?

Re: 2 dimensions 1 election

Wed, 10 Jun 2015 12:46:49 GMT

I put the example. Thanks

Re: 2 dimensions 1 election

Wed, 10 Jun 2015 12:46:52 GMT

I put the example. Thanks

Re: 2 dimensions 1 election

sunny_talwar — Wed, 10 Jun 2015 12:48:42 GMT

What is the expected output?

Re: 2 dimensions 1 election

Wed, 10 Jun 2015 12:52:42 GMT

Only two dimesions.
Nombre and TIpo or ORIGIN.

Re: 2 dimensions 1 election

sunny_talwar — Wed, 10 Jun 2015 12:54:46 GMT

What happens when both of them has value? Does Tipo or Origin takes precedence?

Re: 2 dimensions 1 election

sunny_talwar — Wed, 10 Jun 2015 13:03:57 GMT

Does this look like what you want?

Re: 2 dimensions 1 election

Thu, 11 Jun 2015 05:45:15 GMT

We almost had it!

But 1,2,3 only shows TIPO and 4 and 33 only shows ORIGIN.

Thank you

Re: 2 dimensions 1 election

alex_millan — Thu, 11 Jun 2015 07:24:39 GMT

Hi,

check if the attached file fits your needs.

HTH

Cheers

Re: 2 dimensions 1 election

sorrakis01 — Thu, 11 Jun 2015 07:30:50 GMT

I Think the same If(nombre <=3, Tipo, ORIGIN)

Re: 2 dimensions 1 election

alex_millan — Thu, 11 Jun 2015 07:54:39 GMT

If you wish to show the data for SALES whose 'nombre','Tipo' and 'ORIGIN' are null, just replace the actual expression to Sum(SALES)

Re: 2 dimensions 1 election

Thu, 11 Jun 2015 08:29:48 GMT

Mil gracias Alex.