Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

In one dashboard can we make a selection and it should show the results of another table also in the same screen.

There are 2 tables say table A and B .I need to go to dashboard and click on a selection which displays information related to table A .When i click on that i must also be able to view info related to table B and its vice versa.
Is it possible to achieve this using QlikView?
FYI..Table A we can be taken as Interaction table and table B as Incident table and both contain many columns which are similar so if we join the tables we will lose some of the data.pls sugest.


1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Yes you can do this.

Methods:

  1. Either call both the tables on same application (make sure you are one filed common between two tables called as Primary key)
  2. You can do this by using binary load.

The binary load statement is used for loading the data from another QlikView document, the binary load appears  always top in the script.Only one binary load statement is allowed in the script and it can only be put as the first statement of a script

Open Qlikview Edit Script and click on Qlikview File tab then select Existing QVW and give ok.

Better if you refer the reference manual where you get all answers.


Thanks,

AS

7 Replies
amit_saini
Honored Contributor III

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Rekha,

Are you calling both these tables on same sheet or they are on two different dashboards????

Thanks,

AS

Not applicable

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.


Hi Amit,

Preferably I want to show the results on the same dashboard.Is it possible to show the results on the same dashboard calling them in the same sheet?

satyadev_j
Valued Contributor

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Just wanted to understand bit more here, when you say "you will lose data after joining two table" what kind of join you are applying there? By doing simple "Join" or "Concatenate" will not lose any data. Let me know your view.

amit_saini
Honored Contributor III

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Yes you can do this.

Methods:

  1. Either call both the tables on same application (make sure you are one filed common between two tables called as Primary key)
  2. You can do this by using binary load.

The binary load statement is used for loading the data from another QlikView document, the binary load appears  always top in the script.Only one binary load statement is allowed in the script and it can only be put as the first statement of a script

binary load.PNG.png

Open Qlikview Edit Script and click on Qlikview File tab then select Existing QVW and give ok.

Better if you refer the reference manual where you get all answers.

Thanks,

AS

amit_saini
Honored Contributor III

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Yes you can do this.

Methods:

  1. Either call both the tables on same application (make sure you are one filed common between two tables called as Primary key)
  2. You can do this by using binary load.

The binary load statement is used for loading the data from another QlikView document, the binary load appears  always top in the script.Only one binary load statement is allowed in the script and it can only be put as the first statement of a script

Open Qlikview Edit Script and click on Qlikview File tab then select Existing QVW and give ok.

Better if you refer the reference manual where you get all answers.


Thanks,

AS

Not applicable

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Hi Amit and Satyadev,

I have joined both the tables using left join with the primary key as the Incident ID .I am getting the data as required.

Thanks for ur reply.

amit_saini
Honored Contributor III

Re: In one dashboard can we make a selection and it should show the results of another table also in the same screen.

Rekha,

Please close the thread by marking correct or help answer.

Thanks,

AS

Community Browser