calculate diference between dimension records.

Tue, 04 Sep 2012 17:45:33 GMT

Hi,

I need some one´s help for the following scenario:

For a table with, Month as a dimension and a expression sum(Sales), how can I calculate the sales percentage evolution average per month?

For that I need to pick the current month(dimension) and sales record and the previous month(dimension) and sales record. Iam not sure if I may have to do it on the script before load or if there is a way to put in a expression?

I really appreciate your help.

Att,

Jorge

Re: calculate diference between dimension records.

MayilVahanan — Tue, 04 Sep 2012 18:14:14 GMT

For average, you can use like this,

=Sum(Sales)/Sum(total Sales)

Single dimension only r u using?

topic Re: calculate diference between dimension records. in QlikView

calculate diference between dimension records.

Re: calculate diference between dimension records.