topic combining 3 charts into one in QlikView

combining 3 charts into one

Anonymous — Sun, 26 Jun 2016 07:44:27 GMT

Hi Geniuses,

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.

Thanks,

agni_gold — Sun, 26 Jun 2016 07:55:03 GMT

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.

marcus_sommer — Sun, 26 Jun 2016 08:18:34 GMT

You could use a cyclic dimension group: Did you know..? Cyclic Group

- Marcus

varshavig12 — Sun, 26 Jun 2016 08:28:35 GMT

Simply create a new cyclic group:

Go to:

Properties

Dimensions

Edit groups

Create a 'new' group and select 'cyclic' group

add your dimensions i.e first dimension of all the three charts.

---------------------------------