Dynamic Parameter and What if Analysis - Qlik Community

Report Inappropriate Content · ‎2013-09-02

Hello Experts,

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.

Many Thanks,

Nish

vikasmahajan · ‎2013-09-02

PFA

also link

http://community.qlik.com/message/205998#205998

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

kaushiknsolanki · ‎2013-09-02

Hi,

Have a look at the attachment.

I have modified the excel to fit in the requirement.

Regards,

Kaushik Solanki

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

Report Inappropriate Content · ‎2013-09-02

Hello Kaushik,

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.

Regards,

Nish

kaushiknsolanki · ‎2013-09-02

Hi,

Can you please explain with an example.

Regards,

Kaushik Solanki

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

Report Inappropriate Content · ‎2013-09-02

Hi Kaushik,

Please find the modified excel attached. I hope this gives better understanding of the scenario.

Regards,

Nish

Report Inappropriate Content · ‎2013-09-03

Hello,

Kaushik Solanki Any luck with the attached ? Was my excel clear enough ?

Thanks,

Nish