topic How can develope a simulation in Qlikview? in QlikView

How can develope a simulation in Qlikview?

Thu, 16 Apr 2015 08:04:09 GMT

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

Re: How can develope a simulation in Qlikview?

jpenuliar — Thu, 16 Apr 2015 08:35:02 GMT

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".

Re: How can develope a simulation in Qlikview?

maleksafa — Thu, 16 Apr 2015 08:38:13 GMT

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.

Re: How can develope a simulation in Qlikview?

Thu, 16 Apr 2015 09:25:28 GMT

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

Re: How can develope a simulation in Qlikview?

buzzy996 — Thu, 16 Apr 2015 09:30:51 GMT

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.

Re: How can develope a simulation in Qlikview?

vikasmahajan — Thu, 16 Apr 2015 09:41:19 GMT

pfa documents

Vikas

Re: How can develope a simulation in Qlikview?

Fri, 17 Apr 2015 07:26:13 GMT

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.