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.

[alex_millan · Accepted solution]

Hi,

check if the attached file fits your needs.

HTH

Cheers

[sorrakis01]

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

[alex_millan]

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

[#5]

Mil gracias Alex.