Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to use a macro to select just one value from a SQL Server Database or a can obtain information direct from the memory?
What's the best way to do that?
Exemple:
SELECT @VariableName = name FROM users WHERE nif = 123
Which code I have to use?
Could you send me a exemple or a qlik file that explain what to do?
Thank you so much.
Regards,
Nuno Maximiano.
Before running the macro, you can put the value in a variable and use the variable in the macro.
hi,
try the following:
users:
sql select name as NAME
from
users WHERE nif = 123;let vVariableName=peek('NAME',-1,users);
drop table users;
The goal is to have a button on the screen to validate that the NIF input by user (in input box) exists in the database.
Any Ideas?
You can try this.
Only({$<nif={$(vNifInput)}> Name}
Best Regards.
Tonial.
But i need to use a macro...
Any ideias?
Before running the macro, you can put the value in a variable and use the variable in the macro.