topic Obtain one value in QlikView

Obtain one value

Thu, 28 Jul 2011 11:24:47 GMT

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.

pat_agen — Thu, 28 Jul 2011 13:24:06 GMT

hi,

try the following:

users:

sql select name as NAME

from

users WHERE nif = 123;

let vVariableName=peek('NAME',-1,users);

drop table users;

Thu, 28 Jul 2011 14:09:05 GMT

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?

Thu, 28 Jul 2011 14:30:41 GMT

You can try this.

Only({$<nif={$(vNifInput)}> Name}

Best Regards.
Tonial.

Thu, 28 Jul 2011 14:56:31 GMT

But i need to use a macro...

Any ideias?

Thu, 28 Jul 2011 16:09:50 GMT

Before running the macro, you can put the value in a variable and use the variable in the macro.