topic Re: Set Analysis AND/OR condition in QlikView

Set Analysis AND/OR condition

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

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

Re: Set Analysis AND/OR condition

MK_QSL — Mon, 23 Apr 2018 09:33:14 GMT

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.

Re: Set Analysis AND/OR condition

sasiparupudi1 — Mon, 23 Apr 2018 11:06:14 GMT

May be try

Count(

{

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

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

} asset)

Re: Set Analysis AND/OR condition

sunny_talwar — Mon, 23 Apr 2018 11:13:25 GMT

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)

Re: Set Analysis AND/OR condition

karan_kn — Mon, 23 Apr 2018 14:16:07 GMT

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)

Re: Set Analysis AND/OR condition

sunny_talwar — Mon, 23 Apr 2018 14:18:03 GMT

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

Re: Set Analysis AND/OR condition

sunny_talwar — Mon, 23 Apr 2018 14:20:09 GMT

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)

Re: Set Analysis AND/OR condition

karan_kn — Mon, 23 Apr 2018 14:32:12 GMT

Perfect Thanks