Set Analysis AND/OR condition

[karan_kn]

Please help me on to fix this set Analysis script, type field not working when I use '+'

=Count({<type={'doc'},date={""} >+<date={">$(=Date(Today()))"}>} asset)

Type= doc

Date= Null or  >Today()

[MK_QSL]

May be create a backend flag

IF(Len(Trim(Date))=0,1) as null_Date

and use as below

=COUNT({<Type = {'Doc'}>*(<null_Date = {1}>+<Date = {">=$(=Date(Today()))"}>)}Asset)

Note that Type, Doc, Date, Asset all are case sensitive.

[sasiparupudi1]

May be try

Count(

{

<type={'doc'},date={"=Len(Trim(date))=0"} >+

<type={'doc'},date={">$(=Date(Today()))"}>

} asset)

[sunny_talwar]

Extend this further may be like this by creating a new field like this

Date(If(Len(Trim(Date)) = 0, AddYears(Today(), 1), Date)) as NewDate

and then this

=Count{<Type = {'Doc'}, NewDate = {">$(=Date(Today()))"}>} Asset)

[karan_kn]

Thanks, can some one help with multiple operator using Set Analysis

=Count(type='doc' or (type='lib' and folder not like '%/drive/%'))

and (date='' or date>Today) asset)

[sunny_talwar]

Once again, why can't you just create flags in the script? unless you have a specific reason to do this on the front end, I would suggest to create flags in the script to do this

[sunny_talwar · Accepted solution]

Something like this

If((type = 'doc' or (type = 'lib' and not folder like '%/drive/%')) and (Len(Trim(date)) = 0 or date > Today()), 1, 0) as Flag2

and then this:

Count({<Flag = {1}>} asset)

[karan_kn]

Perfect Thanks