What if analysis

[Anonymous]

Hi All,

Please let me know how to achieve what if analysis in a table , user inputs some values and the value has to updated in the table

Example

UserInput:

Designation , Country , state, City , No

      X          ,   India , Maharashtra, Mumbai , 10

      Y          ,  India   , Karnataka,  Bangalore, 20 

      Z           , Tamil Nadu, Chennai   , 40

I have a pivot table like the below

Designation , Country , state, City

      A          , India,   Maharashtra,  Pune

      B          , India ,   Tamil Nadu,  Kovai

      X          ,   India , Maharashtra, Mumbai

      Y          ,  India   , Karnataka,  Bangalore

      Z           , Tamil Nadu, Chennai  

my result should be

      Designation , Country , state, City , No

      A          , India,   Maharashtra,  Pune, -

      B          , India ,   Tamil Nadu,  Kovai , -

      X          ,   India , Maharashtra, Mumbai, 10

      Y          ,  India   , Karnataka,  Bangalore , 20

      Z           , Tamil Nadu, Chennai , 40 

[raviityou]

find attached file hope this will help you.

[sunny_talwar]

Where are you expecting the user to update the data? through script or front end?

[agarwalrits13]

Hi Shan,

I had used What if Analysis in one of my sample doc. I have attached same qvw document which might be helpful to you.

[Siva_Sankar]

Here is my document posted 6 years ago. What If Analysis in Qlikview.docx