topic Set analysis syntax in QlikView

Set analysis syntax

Anonymous — Sun, 08 Feb 2015 12:12:21 GMT

Hi All,

How to find greater than in set analysis

example

if(AppointmentDate>Order_date, count(Reason),0)

How to add the above statement in set analysis

Thanks in advance

Re: Set analysis syntax

Anonymous — Sun, 08 Feb 2015 12:31:50 GMT

Hi Shanmuga,

Please try:

In UI use below expression in set analysis
Count ({<(AppointmentDate = {"=AppointmentDate > Order_date"} >} Reason)

or

Count(if(AppointmentDate > Order_date,Reason))

or

Create a flag in Script:

if( AppointmentDate >Order_date,1,0) as Dateflag,

and in UI use below expression in set analysis:

count({<Dateflag={1}>} Reason)

Regards

Neetha

Re: Set analysis syntax

PrashantSangle — Sun, 08 Feb 2015 12:44:34 GMT

Hi,

Try something like this,

Count({<AppointmentDate={">$(=Order_date)"}>}Reason)

count(if(AppointmentDate>Order_date,Reason,0))

Regards,