Add values with input object fot what if analysis?

[Anonymous]

Is there a way to add fieldvalues with an input object in qlikvew?

I have a project where i need to be able to input "what if" values. and later on export these values so that they could be imported in a data warehouse.

Thanks in andvance!

[goldnejea8]

You could assign the input values to a variable, then display the variable in a table box or chart object and then export to excel.  Then you could later import them into your data warehouse.

[Anonymous]

Problem is that i need the variable to be associated to a dimension. Can that be done?

[goldnejea8]

Can you give an example of what you are trying to do?

[Anonymous]

I have the dimensions, Year and Profession. The expression is average sallary. The other expression is suppose to be a "what if" expression. What if the average sallry is ...

So that what is sallary needs to be in a variable. And i'ts not acceptable to have the variable in a procentage. it needs to be the actual average sallary for the what if analysis.

[goldnejea8]

You could have expression be something like avg(SALARY+vWHATIF), where the vWHATIF is adding or subtracting to the total salary.

[Anonymous]

hm. that could be acceptable. thank you for the advice!