topic Re: script help please in App Development

?

xyz1 — Sun, 14 Apr 2019 13:21:32 GMT

Re: script help please

kaushiknsolanki — Mon, 13 Feb 2017 07:12:32 GMT

Hi Agrim,

First of all please do not create multiple post of same question.

Now I am going through your excel, can you tell me what is the logic written because I am not excel expert. It would be helpful if you take one emp as example and explain how the values are arrived.

Regards,

Kaushik Solanki

?

xyz1 — Sun, 14 Apr 2019 13:22:23 GMT

Re: script help please

kaushiknsolanki — Mon, 13 Feb 2017 07:23:36 GMT

Hi,

Its not possible to understand what you have in applymap.

Can you explain as per your excel. Like how did you got that value for M1. I assume that M1 logic is same in other sheets like M2,M3.... and so on, excel a month change.

Regards,

Kaushik Solanki

?

xyz1 — Sun, 14 Apr 2019 13:24:28 GMT

Re: script help please

kaushiknsolanki — Mon, 13 Feb 2017 10:33:47 GMT

Agrim,

I am still not getting the logic..

I dont want to see what logic you applied in Qlik.

I want a generic logic. Meaning what is being multiplied by what and when?

Hope its clear.

Regards,

Kaushik Solanki