topic How to make a multiple table in App Development

How to make a multiple table

lichang422 — Thu, 07 Dec 2017 15:26:03 GMT

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!!

Re: How to make a multiple table

felipedl — Thu, 07 Dec 2017 16:59:21 GMT

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

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.

Re: How to make a multiple table

pedrobergo — Thu, 07 Dec 2017 17:09:43 GMT

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