Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Index Price

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Index Price

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

6 Replies
Not applicable

Index Price

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_purchaseProductproduct_numberunitpriceVarIndex
ene-10A101010150-100
feb-10A1010101548%                 108
mar-10A10101018354%                 166
ene-11A10101019818%                 196
feb-11A101010155-44%                 110
mar-11A10101017129%                 142
ene-10BB1919180-100
feb-10BB191918911%                 111
mar-10BB1919188-1%                 110
abr-10BB1919180-9%                 100
ene-11BB19191856%                 106
feb-11BB1919181-5%                 101
mar-11BB19191877%                 109
Not applicable

Re: Index Price

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

Not applicable

Re: Index Price

It is developed in excel (see the attach)

how can we do it by QV?

some knows???

it will be really reallly helpfull....

Not applicable

Re: Index Price

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

AE

Not applicable

Re: Index Price

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

Not applicable

Re: Index Price

Stefan

Thanks toooo much.....

it was perfect !!!!!

AE

Community Browser