Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

combining 3 charts into one

Hi Geniuses,

I have 3 charts like below

Charts.jpg

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,

S

3 Replies
agni_gold
Specialist III
Specialist III

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

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

- Marcus

varshavig12
Specialist
Specialist

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.

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