# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for
Did you mean:
Creator

## SUM VARIABLES IN VARIABLE OVERVIEW

Hi everybody:

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

The variables are:

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:

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?

9 Replies
Specialist

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

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator

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.

Master III

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

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator

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.

Master III

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])

MVP