topic Re: copy variable calculation to another variable in QlikView

copy variable calculation to another variable

Wed, 09 Apr 2014 16:33:29 GMT

Hi all,

I need to copy an variable calculation result to another variable or qvd that I will use in order to compare between the two versions.

Lets say i have the vTest=count(volume)

The calculation of this variable in the interface gives me 10.

Is there any way to copy this result to another variable vTest2??

I have managed to do that with triggers but it does not work on the server side

Re: copy variable calculation to another variable

MK_QSL — Wed, 09 Apr 2014 16:40:21 GMT

Please check enclosed file...

Re: copy variable calculation to another variable

Wed, 09 Apr 2014 16:47:35 GMT

Hi,

Just simply assign the variable name to new variable.

eg :

let var1=(some calculation);

let var2 = var1;

Re: copy variable calculation to another variable

Wed, 09 Apr 2014 16:48:30 GMT

In your particular example I would want to get the sum(sales) value which is 500 to another variable but this has to be done without using the variable itself.

I want do do that because every time I reload I want to compare the old variable value with the new one.

Re: copy variable calculation to another variable

Wed, 09 Apr 2014 16:52:29 GMT

But wont this override the new value ?? I want something like versioning kind of.