Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!