Discussion Board for collaboration on QlikView Layout & Visualizations.
I have 3 charts like below
The dimensions of the first chart is 'Total Number of records'(hardcoded) and client
The dimensions of the Second chart is 'Active Number of records'(hardcoded) and client
The dimensions of the Third chart is Supplier Type and client
All the three charts have different formulas to calculate the data
now what i want is to merge all these 3 charts into 1 pivot table
Is it possible
please help me.
Can you please provide some sample data or sample application , so that it will be very easy to help you.
Else you need to perfect your data model first , then you can do this.
You could use a cyclic dimension group: Did you know..? Cyclic Group
Simply create a new cyclic group:
Create a 'new' group and select 'cyclic' group
add your dimensions i.e first dimension of all the three charts.