2 dimensions 1 election

[#1]

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:

1

2

3

4

5

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.

[sunny_talwar]

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

[Kushal_Chawda]

Can you please explain with example and desired output ?

[#4]

I put the example. Thanks

[#5]

I put the example. Thanks

[sunny_talwar]

What is the expected output?

[#7]

Only two dimesions.
Nombre and TIpo or ORIGIN.

[sunny_talwar]

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

[sunny_talwar]

Does this look like what you want?

[#10]

We almost had it!

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

Thank you