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

[Rkota]

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

[sunny_talwar · Accepted solution]

May be try using set analysis here:

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

[Rkota]

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

[sunny_talwar]

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

[rupamjyotidas]

Please close the discussion

[Rkota]

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

[rupamjyotidas]

Try This

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

Do check on the date format

[swuehl]

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])

[Rkota]

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....

[Rkota]

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