topic Re: What if analysis in QlikView

What if analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 24 Jul 2018 11:08:36 GMT

find attached file hope this will help you.

sunny_talwar — Tue, 24 Jul 2018 11:16:56 GMT

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

agarwalrits13 — Tue, 24 Jul 2018 18:40:04 GMT

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 — Wed, 25 Jul 2018 03:13:13 GMT

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