Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
inigoelv
Creator
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:

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.

Example.JPG

Any idea?

Thanks in advance

9 Replies
qlikmsg4u
Specialist
Specialist

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

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


Untitled.png

jonathandienst
Partner - Champion III
Partner - Champion III

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.

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

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.

sasiparupudi1
Master III
Master III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
inigoelv
Creator
Creator
Author

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.

sasiparupudi1
Master III
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])

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

swuehl
MVP
MVP

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

inigoelv
Creator
Creator
Author

Hi Sasidhar:

Really, this is the correct solution.

It works well.

Thank you.