Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Dynamic Parameter and What if Analysis

  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

6 Replies
vikasmahajan
Honored Contributor III

Re: Dynamic Parameter and What if Analysis

Re: Re: Dynamic Parameter and What if Analysis

Hi,

    Have a look at the attachment.

    I have modified the excel to fit in the requirement.

Regards,

Kaushik Solanki  

Not applicable

Re: Dynamic Parameter and What if Analysis

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

Re: Dynamic Parameter and What if Analysis

Hi,

     Can you please explain with an example.

Regards,

Kaushik Solanki

Not applicable

Re: Re: Dynamic Parameter and What if Analysis


Hi Kaushik,

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

Regards,

Nish

Not applicable

Re: Dynamic Parameter and What if Analysis

Hello,

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

Thanks,

Nish

Community Browser