load/save calculated variable to QVD

[#1]

Hi!

Currently reciving a file daily and I need to calculate some stuff from it and then save that to a QVD.

Expressions are loaded from excel and used in pivot.

When I do this

load
'=$(vM_Merchants_ant)' as meracants
AutoGenerate 1;

I save the expression, I need to save the result.

[sebastiandperei]

The structure is:

If vxM_Merchants_ant <>'' then

          Let vxM_Merchants_ant=vxM_Merchants_ant              (why want to do this??);

     Else

          Let vxM_Merchants_ant='';

End If;

But, this conditional has 2 contradictions:

- If V<>'' then V=V?????

- if V='' THEN V=""   (the second chance of IF will occur when the condition is false, or the opposite of the condicion is true, like this case)

Sorry for my bad engrlish, but i cant understand what you needs... Try to explain better please.