Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes you can do this.
Methods:
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
Rekha,
Are you calling both these tables on same sheet or they are on two different dashboards????
Thanks,
AS
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?
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.
Yes you can do this.
Methods:
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
Yes you can do this.
Methods:
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
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.
Rekha,
Please close the thread by marking correct or help answer.
Thanks,
AS