topic Re: SUM VARIABLES IN VARIABLE OVERVIEW in QlikView

SUM VARIABLES IN VARIABLE OVERVIEW

inigoelv — Fri, 17 Jul 2015 09:46:18 GMT

Hi everybody:

I am trying to do a sum of variables in variable overview and only calculate the first one:

The variables are:

vManoObraDirecta=Sum({<[TASAS HORARIAS]={"Mano obra directa:"}>} [€/hora activa de trabajo])/$(vProductividadProduccion)

vManoObraIndirectaResto= Sum({<[TASAS HORARIAS]={"Mano obra indirecta (resto):"}>} [€/hora activa de trabajo])/$(vProductividadProduccion)

If I insert them in individuals columns like (=$(vManoObraDirecta)) it works well.

But the problem is when I try to do a sum of the two variables in the variable overview:

$(vManoObraDirecta)+$(vManoObraIndirectaResto)

only calculate the first of them: $(vManoObraDirecta).

If I change the position: $(vManoObraIndirectaResto)+$(vManoObraDirecta) calculate the other but doesn´t sum the second.

Any idea?

Thanks in advance

Re: SUM VARIABLES IN VARIABLE OVERVIEW

qlikmsg4u — Fri, 17 Jul 2015 09:50:44 GMT

may be you are missing to Put "=" sign before $(vManoObraIndirectaResto)+$(vManoObraDirecta)

like vVariable3 = (=$(vManoObraIndirectaResto)+$(vManoObraDirecta))

Re: SUM VARIABLES IN VARIABLE OVERVIEW

jonathandienst — Fri, 17 Jul 2015 10:03:44 GMT

I am not sure of the definition of vProductividadProduccion, but I would add these two like this:

=RangeSum(($(vManoObraDirecta)), ($(vManoObraIndirectaResto)))

RangeSum handles the case where one of the expressions is null.

Re: SUM VARIABLES IN VARIABLE OVERVIEW

inigoelv — Fri, 17 Jul 2015 10:20:16 GMT

Hi Jonathan:

The two solutions doesn´t work.

The formul of the productivity is a very long expression:

if([Nº of plies (nº)]=2,if(([Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000))>[Barras / Min],

[Barras / Min]*(Floor(2750/Avg([Width sheet (mm)])))*0.7*60, [Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000)*(Floor(2750/Avg([Width sheet (mm)])))*0.7*60),if(([Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000))>[Barras / Min], [Barras / Min]*(Floor(2750/Avg([Width sheet (mm)])))*0.7*60*7/8, [Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000)*(Floor(2750/Avg([Width sheet (mm)])))*0.7*60*7/8))

It is very strange that only the first variable is well calculated.

Re: SUM VARIABLES IN VARIABLE OVERVIEW

sasiparupudi1 — Fri, 17 Jul 2015 11:06:00 GMT

did try wrapping the variable in num#($(vManoObraDirecta),'#,##0.# ')?

Re: SUM VARIABLES IN VARIABLE OVERVIEW

jonathandienst — Fri, 17 Jul 2015 11:31:51 GMT

Change the double quotes into single quotes, and/or try this:

Sum({<[TASAS HORARIAS]={'Mano obra directa:', 'Mano obra indirecta (resto):'}>} [€/hora activa de trabajo])/ ($(vProductividadProduccion))

If that works, and you want it in a variable, then you can create a single variable.

Re: SUM VARIABLES IN VARIABLE OVERVIEW

inigoelv — Fri, 17 Jul 2015 16:01:57 GMT

Hi Jonathan:

At the end this option is correct but I would have prefer to make work the expression like sum of variables.

Anyway, thank you.

Re: SUM VARIABLES IN VARIABLE OVERVIEW

sasiparupudi1 — Sat, 18 Jul 2015 13:41:15 GMT

You could may be try

vManoObraDirecta=Sum({<[TASAS HORARIAS]={"Mano obra directa:"}>} [€/hora activa de trabajo])

vManoObraIndirectaResto= Sum({<[TASAS HORARIAS]={"Mano obra indirecta (resto):"}>} [€/hora activa de trabajo])

($(vManoObraDirecta)+$(vManoObraIndirectaResto))/$(vProductividadProduccion)

Re: SUM VARIABLES IN VARIABLE OVERVIEW

swuehl — Sat, 18 Jul 2015 14:06:44 GMT

You are not using comments (//) in your variable definitions, right?

Re: SUM VARIABLES IN VARIABLE OVERVIEW

inigoelv — Sat, 18 Jul 2015 15:07:44 GMT

Hi Sasidhar:

Really, this is the correct solution.

It works well.

Thank you.