topic is this correct expression...?? in QlikView

is this correct expression...??

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

Hi all,

can anybody evaluate the below expression please. i want to calculate Sum(NUM_OF_DAYS)/sum(NUM_OF_FULLY_CONSUMED) when NUM_OF_FULLY_CONSUMED is not equal to Zero and type is GDP

Sum({<TYPE={GDP},NUM_OF_FULLY_CONSUMED =-0>}NUM_OF_DAYS)/Sum({<TYPE={GDP},NUM_OF_FULLY_CONSUMED =-0>}NUM_OF_FULLY_CONSUMED)

Re: is this correct expression...??

Chanty4u — Mon, 21 May 2018 13:36:57 GMT

try

Sum({<TYPE={'GDP'},NUM_OF_FULLY_CONSUMED- ={'*'}>}NUM_OF_DAYS)/Sum({<TYPE={'GDP'},NUM_OF_FULLY_CONSUMED - ={'*'}>}NUM_OF_FULLY_CONSUMED)

Re: is this correct expression...??

sunny_talwar — Mon, 21 May 2018 13:38:24 GMT

May be this

Sum({<TYPE={GDP}, NUM_OF_FULLY_CONSUMED -= {'0'}>}NUM_OF_DAYS)/Sum({<TYPE={GDP}, NUM_OF_FULLY_CONSUMED -= {'0'}>}NUM_OF_FULLY_CONSUMED)