topic Re: Sum if in QlikView

Sum if

Thu, 03 Oct 2013 12:11:43 GMT

Hi there,

I require assistance with creating a single sum from these to statement

SUM({<Cores={'<=4'},HardwareStatus={'Base'}>}Processor * 0.20)+

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

Regards

CELAMBARASAN — Thu, 03 Oct 2013 12:15:42 GMT

It is possible only if you have the load in inline like

StatusMultiplier:

Load * Inline [

HardwareStatus, multiplier

Base, 0.20

New, 1];

Then you can simply use

SUM({<Cores={'<=4'},HardwareStatus={'Base', 'New'}>} Processor * multiplier)

Hope it helps

Thu, 03 Oct 2013 12:26:09 GMT

Perfect, thank you

mr_janne — Thu, 03 Oct 2013 12:37:24 GMT

sum({<Cores={'<=4'}>} Processor * if(HardwareStatus='Base',0.20,if(HardwareStatus='New',1,0)))

israrkhan — Thu, 03 Oct 2013 12:41:22 GMT

try this:

(SUM(if({<Cores={'<=4'},HardwareStatus={'Base'}>})Processor) * 0.20) +

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

or this

num(SUM(if({<Cores={'<=4'},HardwareStatus={'Base'}>})Processor) * 0.20, #,##0.00) +

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

Thu, 03 Oct 2013 12:54:37 GMT

#Israr, there is an issue with the syntax

israrkhan — Thu, 03 Oct 2013 13:04:24 GMT

' ' are missing in the second expression, around number format '#,##0.00'

Mon, 07 Oct 2013 14:28:23 GMT

Try that, still doesnt work

I think the problem is by the sum (if(