Normalizing Charts

Anonymous — Fri, 30 Mar 2012 09:12:03 GMT

Hi,

I have the ffg chart:

I am trying to normalize this graph between 0 and 1.

I just need to get the maximum and minimum for each line and then I can normalize it but I can't seem to get this because my expression,

is:

Value/Value1 which is actually equal to max(Value)/max(Value1), but I do not want this,

I want Value/Value1 and also get the MAX(Value) throughout the years. so I can eventually use an expression like the ffg:

(Value/MAX(Value))/(Value1/MAX(Value1)) --> results in 1 all the time which I do not want

PLEASE HELP, this is really important for me to implement.

Kind Regards

Razak

jagan — Fri, 30 Mar 2012 10:09:39 GMT

Hi,

Check this is what you are expecting

= (Value/MAX(TOTAL Value))/(Value1/MAX(TOTAL Value1))

Hope this helps you.

Regards,

Jagan.

topic Normalizing Charts in QlikView