topic simulation in QlikView

simulation

Thu, 30 Jul 2009 13:33:25 GMT

hi everyone,

I wonder if its possible,please look at the attached file.

Each project has his own cost,in addition there is a column that shows the new cost

by changing the value of a variable named simulation. ("what-if" )

Well the users want to do that:

1) selecting one of the projects (lets say proj3)

2) then change the value of the variable simulation (with the bar) to lets say 60 (now they will see at the chart the old cost-360 and the new cost-420) .

3) BUT now when they will undo their selection (press "clear") they what to see that in

the column "simulation" the only value which has been changed is the one corresponding to proj3!

And the other projects hasn't changed their values.

Do you think it is possible??

Thanks in advance

simulation

Thu, 30 Jul 2009 14:51:18 GMT

Hi David,

try to use an InputField.

See attached application.

Good luck!

Rainer

simulation

Thu, 30 Jul 2009 15:29:57 GMT

First of all THANX Rainer.

BUT....

Most of the times the users will use the simulation bar to change the values of all of the projects simultaneously so input field is

not good enough--> by your solution they will need to enter each cell for each project and change it (and there are a lot of projects...).

Another problen is that the simulation bar is in % and if the cost of one project is lets say 140774.53 and they want to see what will

happend if the cost will rise in lets say 22% --->by your solution they will need to calculate it first and then put it in

the new field.......

simulation

Fri, 31 Jul 2009 00:57:24 GMT

anyone.....?

simulation

Oleg_Troyansky — Fri, 31 Jul 2009 01:21:18 GMT

I think you can use Set Analysis functionality to recall the last selection:

sum( {$1} Cost) should return the summarized cost for the previous selection.

Obviously, if they keep selecting and deselecting projects, this calculation will keep changing. Maybe, you can enhance it, combining it with the count of projects:

if count(distinct ProjectID) > 1, sum( {$1} Cost), sum(Cost) ) -

e.g. if more than one project selected, use previous selection, otherwise (single project) just summarize costs for that project.

just a thought...

Oleg

simulation

Sat, 01 Aug 2009 22:22:04 GMT

Well Oleg its looking good!

But still I need to do a bit of fitted to it

pls look at the new file:

when I'm selecting "proj2" for example-all of the prijects are still showen in the chart becuse of the set analysis...

I tried to fit your very nice solution to this simple chart,but couldn't done that....