How can develope a simulation in Qlikview?

[#1]

I work in the pricing departement . I have some products who every products may have different price . also, there are different discount for every products.

I need to create an qlikview application for simulating the best price and the best discount  for the products.

for exaplme if I offer 20% discount, I should put which price?

I show you the sample date:

Product	quantity	Price	Price Total	Discount	New Price Total
A	1	10	10	50%	5
A	5	8	40	20%	32
A	10	7	70	40%	42
B	1	5,5	5,5	30%	3,85
B	6	7	42	40%	25,2

Thanks,

Mona

[jpenuliar]

Hi Mona,

you can probably pick some ideas from below link:

QlikView How To (or Tips & Tricks) Application by Lee Matthews

http://community.qlik.com/docs/DOC-5486

See "What if Tab".

[maleksafa]

i guess what you are looking for is 'what-if' analysis, look for this word in the community and you will find plenty of articles.

[#4]

Thanks  all,I need also  'InputedField', I will try it.

[buzzy996]

u can use what if- analysis with input field,when u change ur percentage offer price from input field then automatically ur product price will change accordingly ur percentages by configuring these things with variable.

[vikasmahajan]

pfa documents

Vikas

[#7]

I've tried "what IF" and "inputedField", but actually I want to create something like a "model linear" in "staright table chart" for predicting the new value of price and discount based on the preveiws values;

I've made it in R , so I want to create it in Qlikview, Is it possible?

P.S: I know how I could create model linear in bar chart.