topic Re: Calculating RTY from FPY in QlikView

Calculating RTY from FPY

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlik Comunity,

I'm new to Qlik. I have a question, how to multiply the values in an expression?

As table above, the value of FPY% are populated in pivot chart and I want to multiply each value from each row to calculate RTY%.

For example:

RTY% = FPY% row 1 * FPY% row 2 * FPY% row 3 * FPY% row 4 * FPY% row 5 * FPY% row 6 * FPY% row 7 * FPY% row 8

RTY% = 90.91% * 90.29% * 98.99% * 100% * 88.66% * 100% * 100% * 100%

RTY% = 72.04%

This can easily done in excel using product() function. How can I do this in Qlik? I want to return the result in a Text Object.

Thank you,

Syazani.

Message was edited by: Muhammad Syazani Nazarudin

sunny_talwar — Mon, 27 Nov 2017 01:34:22 GMT

What is the dimension of your chart? Assuming the Dimension is called Dim1, may be try this

Exp(Sum(Aggr(Log(PassedExp/InputExp), Dim1)))

Anonymous — Mon, 27 Nov 2017 07:52:03 GMT

Hi Sunny,

Thank for your time on answering this question.

I've tried but not working, just shows the value 1. Here's my yield table, which one should be my dimension? process or model number?

sunny_talwar — Mon, 27 Nov 2017 12:04:23 GMT

I would say Process and model number

Exp(Sum(Aggr(Log(PassedExp/InputExp), Process, [model number])))

Anonymous — Mon, 27 Nov 2017 13:33:46 GMT

Thank you very much for your answer, it worked! The final touch would be formatting the text object into percentage with two decimal point.

sunny_talwar — Mon, 27 Nov 2017 15:44:05 GMT

This should do it

Num(Exp(Sum(Aggr(Log(PassedExp/InputExp), Process, [model number]))), '#,##0.00%')

Anonymous — Mon, 27 Nov 2017 15:53:35 GMT

Thank you very much! I really appreciate your help and support!