topic Re: Subtract dimension average from max value in table in QlikView

Subtract dimension average from max value in table

PaulH1 — Fri, 15 Nov 2024 23:28:49 GMT

Hello,

I'd like to write an expression within a table that subtracts the MARKET RATE in each row from the best MARKET RATE. So in the example below the maximum is Italy at 90% for ID 2 so all other values in the Difference column are subtracted from 90%.

Thank you.

Re: Subtract dimension average from max value in table

dplr-rn — Wed, 09 Dec 2020 19:36:01 GMT

i dont know what your data is like but assuming rate isnt aggregated in any way

define difference like so Max(total Rate)- Rate

Re: Subtract dimension average from max value in table

blueran — Wed, 09 Dec 2020 19:45:03 GMT

or instead of total use {1} which ignores all selections

Re: Subtract dimension average from max value in table

PriyankaShivhare — Thu, 10 Dec 2020 06:28:42 GMT

Max(Total<ID> Rate)-Rate

Re: Subtract dimension average from max value in table

pradosh_thakur — Thu, 10 Dec 2020 07:17:06 GMT

If you want the max from all the ids then Max(Total RATE)-RATE

If you want for some specific dimension then Max(Total <dimesnion> RATE)-RATE for ex. Max(Total<ID> RATE)-RATE

-Pradosh