Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
First sorry for my english..
I have 5 sql query, whose select many table. But now, i have an other database with the same name table.
I want to know if it's possible (with the qwd script or macro or other way), to give to the user the choice of the database ?
In the FROM of my query i have to put the name of the database before the table name, can i put a variable link to a listbox with "SQL SHOW DATABASE" ?
If you have any question i'm here, it's important.
cordially.
Hi ShambhuB, thanks
With this solution i have to change the script and create a .txt for each of news databases. If it's was just for me ok, but it's for my colleagues, they are zero
As you are "new" to qlikview, I'd suggest you start simple and just use 2 database sources and hard code it.
When you have got that working, tested and you are confident you understand it, then worry about the loop and the xls.
That is exactly how I started when I was building my solution.
I don't think there is a simple user friendly way to do this.
I think you will need to generate some training materials for your users to assist them.
I have my query with two databases concatenate
sql select * from base10_05.tableA concatenate select * from base14_05.tableA
(thanks for your help)
be damned final user
i've tried something like this :
//connexion a la base
ODBC CONNECT TO BasesPourQVW;
LOAD DataBases,
Choix
FROM
(biff, embedded labels, table is [Bases MySQL$]);
Let vbaseSelected = Choix;
hourlyvalue_time :
SQL SELECT *
FROM $(vbaseSelected).mod_bi_servicemetrics
JOIN $(vbaseSelected).mod_bi_metrichourlyvalue on $(vbaseSelected).mod_bi_servicemetrics.id = $(vbaseSelected).mod_bi_metrichourlyvalue.servicemetric_id ;
But vbaseSelected return nothing.. so -> sql error : No database selected
Use
Let vbaseSelected = 'Choix';
or
Set vbaseSelected = Choix;
it return "choix" not the content
i've done this, it works but i keep the topic not resolve if you have an other solution.
//connexion a la base
ODBC CONNECT TO BasesPourQVW;
LOAD DataBases,
Choix
FROM
(biff, embedded labels, table is [Bases MySQL$]);
Let vbaseSelected = peek('Choix',0);
hourlyvalue_time :
SQL SELECT *
FROM $(vbaseSelected).mod_bi_servicemetrics
JOIN $(vbaseSelected).mod_bi_metrichourlyvalue on $(vbaseSelected).mod_bi_servicemetrics.id = $(vbaseSelected).mod_bi_metrichourlyvalue.servicemetric_id ;
Thanks everybody