topic Pivot Problem in QlikView

Pivot Problem

helen_pip — Tue, 18 Sep 2012 14:44:13 GMT

Hello

I am fairly new to Qlikview and need some advice

Could someone kindly advise me how with using dummy fields "Admitted" and "Non Admitted" how I can get the two dummy fields to show on the left hand side of a pivot table

The example below shows them as seperate, but I ideally want them to appear in a very similar format in 1 pivot table

I ideally would like to look as follows in one table (Kind of):

Thanks

Helen

Re: Pivot Problem

Tue, 18 Sep 2012 14:58:30 GMT

Hi Helen,

If data is supported in diferents tables you can concatenate those making the dummyu field like that,

Table1:

LOAD A

'Admitted' as Status;

SQL SELECT A,B FROM TABLE

cocatenate(Table1):

LOAD A

'Non-Admitted' as Status;

SQL SELECT A,B FROM TABLE2

I hope to help you.

Re: Pivot Problem

helen_pip — Tue, 18 Sep 2012 15:10:22 GMT

Hello,

Thank you for your reply

The data is all coming from one table, but my problem is getting more than one dummy field to show on the left hand side of the pivot table

Re: Pivot Problem

Tue, 18 Sep 2012 15:16:42 GMT

Hi Helen,

In this case you add a calculated dimensión in you pivot table, this dimension evalueta an expresion to determinate if is an addmited or not value.

To add a calculate dimension Pivot Table Properties --> Tab Dimensión --> Button Calculated dimension.

I hope to help you.