? - Qlik Community

xyz1 · ‎2017-02-13

.

kaushiknsolanki · ‎2017-02-13

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

xyz1 · ‎2017-02-13

.

kaushiknsolanki · ‎2017-02-13

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

xyz1 · ‎2017-02-13

.

kaushiknsolanki · ‎2017-02-13

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!