Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

lichang422
Contributor

How to make a multiple table

i want to make a chart with two kind of data

In power BI , it is easy to make it (By make 2 chart and overlap it)

But in qlik , i can not overlap 2 chart in one place

How could i do it

Thank you!!

未命名.jpg

Tags (2)
2 Replies
felipedl
Valued Contributor III

Re: How to make a multiple table

Hi shi,

Do a combo chart in Sense.

With this data:

load * Inline

[

SalesPerson,Product, Sales

Adam,1, 2000

Adam,2, 1000

Bob,3, 300

Bob,5,100

Mary,1, 10000

Mary,2, 5123

Mary,3, 395

Sally,1, 1300

];

And creating a combo chart, gives me the following

Sample.png

Dummy data, but ilustrates that you can get the same behaviour in one single chart object in Sense.

Attached the sample QVF file I created.

pedrobergo
New Contributor III

Re: How to make a multiple table

Hi shih,

Yes, you cannot put two objects at same place in Qlik Sense, but you can do it in QlikView.

However, the Qlik Associative Model allows you to link two or more tables using any field you want, then you can put the both measures at the same graphic.

Create a Master Calendar and connect the two tables to then. Use this example to do that.

How to create master calendar in Qlik Sense

Pedro