Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

View solution in original post

6 Replies
Not applicable
Author

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
Author

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
Author

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
Author

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
Author

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

Not applicable
Author

Stefan

Thanks toooo much.....

it was perfect !!!!!

AE