Discussion Board for collaboration on QlikView Scripting.
I need to dynamically set parameter and calculate total pay - what if analysis depending on the experience.
Please find the data sheet attached.
Can you please suggest how that can be achieved.
Have a look at the attachment.
I have modified the excel to fit in the requirement.
Kaushik Solanki Many Thanks.
In the current scenario I need to calculate the pay depending on current year of experience which vary in every case.
That means I need to use the matrix for calulation matching the year of experience they have and the pay out for that particular year for a given individual.
Vikas Mahajan Thanks for the information.
Can you please explain with an example.
Please find the modified excel attached. I hope this gives better understanding of the scenario.
Kaushik Solanki Any luck with the attached ? Was my excel clear enough ?