topic Re: Price index in QlikView

Price index

MindaugasBacius — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like to calculate the Price Index that depends products basket that was sold on chosen time interval.

Customer chooses the time interval that is used in following calculations:

The percents of Total appears:

Then according to the prices the Index is calculated:

I do only need the Total price index row. Every calculation should be made in front end.

I have attached the Example and the dummy data sample.

Thank you!

Re: Price index

sunny_talwar — Tue, 07 Feb 2017 14:52:45 GMT

Have you created a qvw already? I am feeling lazy to create one if it has been created already?

Re: Price index

MindaugasBacius — Tue, 07 Feb 2017 15:09:52 GMT

Everything I've tried failed.

This qvw is pure.

If you could just please pass me a concept or an idea. Something that I could grab on.

Re: Price index

MindaugasBacius — Wed, 08 Feb 2017 12:03:53 GMT

Any help on this matter would be much appreciated.

Thank you!

Re: Price index

sunny_talwar — Thu, 09 Feb 2017 12:02:06 GMT

So I am here, I am not sure what all dimensions and expressions are needed for the output chart

Do I need to create a pivot table with Code and Year, Month field? or do you need one dimension?

Re: Price index

MindaugasBacius — Thu, 09 Feb 2017 12:11:59 GMT

The final result should be only one row:

One dimension for sure would be [Year, month] as this would appear as a chart.

Re: Price index

sunny_talwar — Thu, 09 Feb 2017 12:20:43 GMT

This?

Sum(Aggr(

(Sum(TOTAL <Code>{<Date = {"$(='>=' & Date(varMinDate, 'YYYY.MM.DD') & '<=' & Date(varMaxDate, 'YYYY.MM.DD'))"}>}[Quantity, kg])/

Sum(TOTAL {<Date = {"$(='>=' & Date(varMinDate, 'YYYY.MM.DD') & '<=' & Date(varMaxDate, 'YYYY.MM.DD'))"}>}[Quantity, kg])) *

(sum([Sum, Eur])/sum([Quantity, kg])), Code, [Year, month]))

Re: Price index

MindaugasBacius — Thu, 09 Feb 2017 12:22:42 GMT

To clarify everything I do need the proportion made of the Quantity and period range that was set by user.

Then this proportion for different code should be as a constant value for the rest of the period. We need to multiply proportion and the price from the different Year, month.

The end outcome is one row of data.

In case you're missing any information refer to me.

Thank you!

Re: Price index

MindaugasBacius — Thu, 09 Feb 2017 12:24:02 GMT

Seems promising!

I will check everything and get back.

Re: Price index

sunny_talwar — Thu, 09 Feb 2017 12:24:35 GMT

Did my response above looks like what you wanted?

Re: Price index

sunny_talwar — Thu, 09 Feb 2017 12:24:48 GMT

Sounds like a plan

Re: Price index

MindaugasBacius — Thu, 09 Feb 2017 12:28:46 GMT

The test results are the same.

Thank you again!

Re: Price index

sunny_talwar — Thu, 09 Feb 2017 12:31:27 GMT

Super