topic Re: PERCENTAGE ON SUM in QlikView

PERCENTAGE ON SUM

PASHA — Thu, 31 Jan 2019 11:21:44 GMT

Dear Team,

Hi Greetings to all ,

I want to do one (a-b)/b formula in my dashboard as a sample.

A formula is sum({$<SALEYEAR={"2019"}>}NETAMT)

B formula is Sum({$<SALEYEAR={2018}>}NETAMT) now hoa can i do A-B/B with this

Thanks.

Re: PERCENTAGE ON SUM

agigliotti — Thu, 31 Jan 2019 11:29:25 GMT

maybe this:
(
sum( {< SALEYEAR = {'2019'} >} NETAMT )
-
sum( {< SALEYEAR = {'2018'} >} NETAMT )
)
/
sum( {< SALEYEAR = {'2018'} >} NETAMT )

Re: PERCENTAGE ON SUM

pradosh_thakur — Thu, 31 Jan 2019 11:33:59 GMT

(sum({$<SALEYEAR={2019}>}NETAMT) - Sum({$<SALEYEAR={2018}>}NETAMT) )
/ Sum({$<SALEYEAR={2018}>}NETAMT)

couple of things to note
1: it's not a good practice to hard code values
2: DOUBLE QUOTES are used as search string, don't use if not necessary.