Multiplication in Qlik Sense

valnod_90 — Mon, 05 Nov 2018 10:59:42 GMT

Hi guys, I need your help.

In my company each order is made up of 11 or 10 production steps that vary depending on whether the bin is present or not.

The presence of the bin is evaluated in the "F_Cassa" field which has the value "1" if the bin is present, or "0" if it is not.

I need Qlik to multiply the number of phases per order and the number of job orders selected considering the value of the "F_Cassa" field.

For example, if I select an order with the bin and one without it Qlik will have to do this operation: 11 x 1 + 10 x 1 and obtain 21 as result.

I tried with an if statement but it doesn't work beacause, for example, in the case above i obtain 20 as result and not 21.

Is there a way to do this?

Thank you

Re: Multiplication in Qlik Sense

undergrinder — Mon, 05 Nov 2018 11:59:07 GMT

Hi Valentina,

could you provide us some example data?

valnod_90 — Mon, 05 Nov 2018 16:00:56 GMT

Hi Gabor,

sure!

Look at the XLS file attached above.

I hope is enough.

Tnx