topic Price Index Normalization in QlikView

Price Index Normalization

Wed, 22 Apr 2009 22:51:25 GMT

Has anyone successfully implemented Price Indexing with normalization (http://en.wikipedia.org/wiki/Price_index) ? I have been able to do the Fisher Ideal, but the problem arises when you try to normalize the indices based on the user selection and you want to only compare one particular month versus the latest selected month.

Price Index Normalization

Thu, 23 Apr 2009 02:23:44 GMT

Hi Brian,

I am not clear with the question. Can you explain it.

Regards,

Amit

Price Index Normalization

Pablo_Robles — Fri, 26 Jun 2009 05:41:47 GMT

Hi Brian,

Have you tried the set analysis with $* option? This option permits add the current selections to the set indicated in expresions.

Can you send the qvw file in order to help you more efficiently?

Regards,

Pablo

Price Index Normalization

Fri, 04 Dec 2009 11:38:02 GMT

I've been trying something similar, but, have not had any luck.

Adding up the following: =sum( current AUP/ last year AUP * Spend Value/ Total Spend ) to get a monthly index. But, I either get allocation error or no data to display...any ideas?

Price Index Normalization

Tue, 08 Dec 2009 05:49:23 GMT

I think I may have answered my own question for once! Here's the formula that appears to give me the desired result:

=AGGR(sum( [Unit Price]/ [2008 AUP] * [Total Spend] / aggr(NODISTINCT sum([Unit Price] * Quantity),Month)),Month)

Gives me a monthly index of price change when comparing receipts to the previous years average unit price (calculated in the script) by part. Awesome! I also am able to obtain an annual total, though not in the same object. but, I'm cool wit dat.