topic Re: Hi create variables in QlikView

Hi create variables

Fri, 19 Jun 2015 02:20:56 GMT

Hi everyone

I would like to use sub routine to create a set of variables, which using the user provided field name as part of the variable so it is easy to distinguish, for example, it is something like:

sub create_variables('field');

let vABC_ & $(vfield) = ....

...

Is it possible to do so? Thanks for your help in advance!

Re: Hi create variables

Gysbert_Wassenaar — Fri, 19 Jun 2015 05:19:30 GMT

I don't understand what you're trying to do. Can you explain in more detail with an example?

Re: Hi create variables

Fri, 19 Jun 2015 05:31:09 GMT

Thanks for your help first.

I would like to create a variable based on the field provided by user. For example, I have a field which name is"qty" in table 1. I pass this value by using sub. Then, the function inside the sub will create a variable by using the field name as a suffix (e.g. vABC_qty ). is it clear now?

Re: Hi create variables

jonathandienst — Fri, 19 Jun 2015 05:38:11 GMT

This should work:

let vABC_$(vfield) = ....

Re: Hi create variables

Gysbert_Wassenaar — Fri, 19 Jun 2015 05:52:33 GMT

Users don't interact with the load script. So this isn't possible in the script.

Re: Hi create variables

Fri, 19 Jun 2015 06:01:57 GMT

Yes! It works! Thank you so much!