Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
helen_pip
Contributor II

Pivot Problem

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

1 Solution

Accepted Solutions
Not applicable

Re: Pivot Problem

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.

3 Replies
Not applicable

Re: Pivot Problem

Hi Helen,

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

Table1:

     LOAD A   

               B

               'Admitted'           as Status;

     SQL SELECT A,B FROM TABLE

cocatenate(Table1):

     LOAD A

               B

               'Non-Admitted'       as Status;

     SQL SELECT A,B FROM TABLE2

I hope to help you.

helen_pip
Contributor II

Re: Pivot Problem

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

Not applicable

Re: Pivot Problem

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.

Community Browser