topic macro transform variable in QlikView

macro transform variable

Tue, 15 Sep 2009 17:26:47 GMT

Hello,

Can I transform this variable in a field? by API?

set v = ActiveDocument.Variables("gg")
v.SetContent "4" , true

Thanks

Best Regards

Slash [:)]

macro transform variable

Tue, 15 Sep 2009 18:00:12 GMT

I'm not sure what you're asking, it appears to me like you have the code there already, what is it that you cannot do?

macro transform variable

Tue, 15 Sep 2009 18:56:41 GMT

The code I posted works .

In the code I posted I wont to convert the variable I create to a field bot from SQL but From VB script.

Thanks

bestrgrds,

Slash

macro transform variable

Tue, 15 Sep 2009 19:21:54 GMT

OK, now I understand your question.

Does your variable have a specific set number of values, i.e. are the options fixed, or can the user type in anything they want to?

If it is a fixed number of options then what I use is a LOAD * INLINE function in the script to create a field that is not linked to the remainder of my data model, this will allow me to build list boxes that the user can select from. Having said that, you can do the same thing anyway with variables by creating a specific list for the variable to choose from.

I don't know of any way to actually create a field in the data model using a macro, although it might be possible, it would be possible to add to options in an existing field!

You probably need to explain a little more about what you are trying to achieve, why you are doing it that way etc, often there are different approaches that can work just as well.

Cheers,

macro transform variable

Tue, 15 Sep 2009 20:06:33 GMT

Ok. I understand.

If I create this inline:

Load * Inline [

val

];

I created one field called val. Now Can I transform in VB S the variable in field?

Thanks

Best regrds

Slash

macro transform variable

Anonymous — Tue, 15 Sep 2009 20:15:05 GMT

Slash,
The difference between variables and fields:
Variable is a named piece of data that has one and only one value at any given moment. The value can be set manually or in the script or by macro.
Field is as set of values (maybe one, or even none). Values in the field can be selected or not. Selection can be made manually or by a macro. The set of values in the field can be changed only by reload, as far as I know. (I'm intentially leaving aside dynamic update.)
I hope it will help you to better fromulate your question.

macro transform variable

Tue, 15 Sep 2009 20:47:18 GMT

jey Iknow the difference .

I ave to convert a variable build just 1 record in one field build hust one record. I know is possible in sql .

If I have a variable calle d=0

I can convert it to a field A =0

JUST one record.

However I solved .

byse and thank you

Slash

macro transform variable

Anonymous — Wed, 16 Sep 2009 19:26:58 GMT

macro transform variable

Fri, 12 Mar 2010 15:09:16 GMT

Hi,

I hate to hijack the thread, but I cannot see anyything else that fits my query...

I want to create an intput field that will allow a max of 50 inputs from the web user. I then want them to be able to call them up by a macro button .

So simply - enter a customer details that have to be called back before close of shift. I know that if the PC goes off they lose the data as it's just in the buffer. But it means they don't need paper and pen.

Possible??

Thanks

Peter