Hola, tengo un problema con la lógica de variables y cómo hacer recargas según su valoración, en el ejemplo siguiente se cumple la condición de Sum(fabs(Factor_Distrib_CAAP)) es igual a 1 por lo tanto la carga debe cumplirse en el primer IF.
Hi, I work in QS and i have to do something like this, but if vDistrib_CAAP = 1 this doesnt work like i want
Distribucion_CAAP: NoConcatenate LOAD Mercado as Mercado_Distrib_CAAP, Sum(Valor_Distrib/Valor_Distrib_Total) as Factor_Distrib_CAAP Resident Distribucion_CAAP_1 Group by Mercado;
Let vDistrib_CAAP = 'Sum(fabs(Factor_Distrib_CAAP))';
Distribucion_Margen: NoConcatenate LOAD Mercado as Mercado_Distrib_Margen, Sum(Valor_Distrib/Valor_Distrib_Total) as Factor_Distrib_Margen
Let vDistrib_Margen = 'Sum(fabs(Factor_Distrib_Margen))';
IF '$(vDistrib_CAAP)=1' then
LOAD Mercado_Distrib_CAAP as Mercado_Distrib, "Factor_Distrib_CAAP" as Factor_Distrib Resident Distribucion_CAAP;
ElseIF '$(vDistrib_Margen)=1' then LOAD Mercado_Distrib_Margen as Mercado_Distrib, "Factor_Distrib_Margen" as Factor_Distrib Resident Distribucion_Margen;
Else
LOAD Mercado_Distrib_CLP as Mercado_Distrib, "Factor_Distrib_CLP" as Factor_Distrib Resident Distribucion_CLP;
