topic Re: Index Price in QlikView

Index Price

Thu, 02 Jun 2011 20:19:18 GMT

How can I calculate index price of each product?

I have in my base number_item, date_of_purchase, unit_price and supplier.

I would like to know the firt price of purchase and the last one, to realice how the price grow betweent those dates...

any ideas?

thanks

Angela E

Index Price

Thu, 02 Jun 2011 21:13:29 GMT

It is developed in excel (see the attach)

how can we do it by QV?

some knows???

it will be really reallly helpfull....

date_of_purchase	Product	product_number	unitprice	Var	Index
ene-10	A	1010101	50	-	100
feb-10	A	1010101	54	8%	108
mar-10	A	1010101	83	54%	166
ene-11	A	1010101	98	18%	196
feb-11	A	1010101	55	-44%	110
mar-11	A	1010101	71	29%	142
ene-10	BB	19191	80	-	100
feb-10	BB	19191	89	11%	111
mar-10	BB	19191	88	-1%	110
abr-10	BB	19191	80	-9%	100
ene-11	BB	19191	85	6%	106
feb-11	BB	19191	81	-5%	101
mar-11	BB	19191	87	7%	109

Re: Index Price

Thu, 02 Jun 2011 21:16:20 GMT

Hi Angela,

the following script will give you the result:

RawData:
LOAD date_of_purchase, 
     Product, 
     product_number, 
     unitprice,
     if(Product = peek(Product), (unitprice - peek(unitprice))/peek(unitprice)) as Var,
     if(Product = peek(Product), (1+Var)*peek(Index),100) as Index
FROM IndexExample.xlsx (ooxml, embedded labels, table is Hoja1);

Hope this helps!

Stefan

Re: Index Price

Thu, 02 Jun 2011 21:22:38 GMT

It is developed in excel (see the attach)

how can we do it by QV?

some knows???

it will be really reallly helpfull....

Re: Index Price

Thu, 02 Jun 2011 21:39:55 GMT

Excellent Stefan

thanks a lot...

could you give me a extra help please?

now i need to make my resume...

i mean...

i need to evaluate last index price, avr price, first price, and last price

by year by product...

i am a begginer and if you can help would be more than great...

tahnks...

Re: Index Price

Thu, 02 Jun 2011 22:46:17 GMT

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

Re: Index Price

Fri, 03 Jun 2011 01:05:55 GMT

Stefan

Thanks toooo much.....

it was perfect !!!!!