Discussion board where members can get started with QlikView.
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):
Go to Solution.
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.
If data is supported in diferents tables you can concatenate those making the dummyu field like that,
'Admitted' as Status;
SQL SELECT A,B FROM TABLE
'Non-Admitted' as Status;
SQL SELECT A,B FROM TABLE2
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