topic Re: need help please - multiple conditions in Sum(If...) in QlikView

need help please - multiple conditions in Sum(If...)

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

Hello - Having issues with this statement....obviously doing something wrong....would greatly greatly appreciate any pointers to fix this/get it working

SUM(If(<PoolName='COCP' and Month=Date(Today(),'MMM')> [24Hrs WO]))

so essentially i'm trying to get a SUM only if both conditions are satisfied beore the [24Hrs WO]

Thx

Re: need help please - multiple conditions in Sum(If...)

sunny_talwar — Wed, 23 Nov 2016 15:43:10 GMT

May be try using set analysis here:

Sum({<PoolName = {'COCP'}, Month = {"$(=Month(Today()))"}>} [24Hrs WO])

Re: need help please - multiple conditions in Sum(If...)

Rkota — Wed, 23 Nov 2016 16:30:49 GMT

Sunny T(he) man.......Worked!!!. Thanks a lot..Appreciate your help...

Re: need help please - multiple conditions in Sum(If...)

sunny_talwar — Wed, 23 Nov 2016 16:36:38 GMT

Awesome!!! Please close this thread by marking correct response if you got what you were looking for

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: need help please - multiple conditions in Sum(If...)

rupamjyotidas — Wed, 23 Nov 2016 16:36:48 GMT

Please close the discussion

Re: need help please - multiple conditions in Sum(If...)

Rkota — Wed, 23 Nov 2016 20:04:37 GMT

need help again....must be something simple that I'm gravely missing

Sum({<PoolName = {'COCP'}, Month=Date((AddMonths(Today(),-1)),'MMMM')>} [24Hrs WO])

This does not return anything...all i'm trying to do is retrieve data from he previous month...

Thanks for any help/assistance

Re: need help please - multiple conditions in Sum(If...)

rupamjyotidas — Wed, 23 Nov 2016 20:14:04 GMT

Try This

Sum({<PoolName = {'COCP'}, Month = {"$(=Month(AddMonths(Today(),-1)))"}>} [24Hrs WO])

Do check on the date format

Re: need help please - multiple conditions in Sum(If...)

swuehl — Wed, 23 Nov 2016 20:15:33 GMT

Please have a look at

A Primer on Set Analysis

Dates in Set Analysis

and also the relevant HELP pages.

If your month values have been created using Month() function, try

Sum({<PoolName = {'COCP'}, Month={'$(=Month(AddMonths(Today(),-1)))'} >} [24Hrs WO])

Re: need help please - multiple conditions in Sum(If...)

Rkota — Wed, 23 Nov 2016 20:23:59 GMT

thanks Rupam....worked. I realized my mistake..tried to convert the month to a string...and in the process set it to NULL/Blanks/Nada..

Thanks and appreciate the quick response....

Re: need help please - multiple conditions in Sum(If...)

Rkota — Wed, 23 Nov 2016 20:25:27 GMT

thanks Stefan....worked as well. Thanks for the links to set analysis

Thanks and appreciate the quick response....

Gobble Gobble - if that's on the agenda this week