topic How can I convert if condition into set analysis in QlikView

How can I convert if condition into set analysis

Fri, 04 Feb 2011 04:47:03 GMT

[

IF (Enrollment.expStartDate = Date(Today() ) and Enrollment.sySchoolStatusID =5 ,Count(Enrollment.syStudentID)
/
IF(Enrollment.expStartDate = Date(Today() ),Count(Enrollment.syStudentID)

]

Above if condition is not working . I would like to know the correct way to resolve it either by if condition or through set analysis.

Thanks.

How can I convert if condition into set analysis

Fri, 04 Feb 2011 07:41:03 GMT

Count(if(Enrollment.expStartDate = Date(Today() ) and Enrollment.sySchoolStatusID =5 ,Enrollment.syStudentID)

/Count(IF(Enrollment.expStartDate = Date(Today() ),Enrollment.syStudentID))

Please try above .

How can I convert if condition into set analysis

Miguel_Angel_Baeyens — Fri, 04 Feb 2011 08:08:30 GMT

With Set Analysis it should look like this:

Count({< Enrollment.expStartDate = {'$(=Date(Today()))'}, Enrollment.sySchoolStatusID = {5} >} Enrollment.syStudentID) / Count({< Enrollment.expStartDate = {'$(=Date(Today()))'} >} Enrollment.syStudentID)

Hope that helps

How can I convert if condition into set analysis

Sat, 05 Feb 2011 00:37:17 GMT

Thanks . But I think I have another problem may be in script or declaring dimension.

Please , see the attachment accepted.qvw

Thanks in advance.

How can I convert if condition into set analysis

Sat, 05 Feb 2011 00:40:09 GMT

Thanks . I am newbie to qlikview .But I think there is something wrong with my script or declaring dimension in chart

I have attached the accepted.qvw

Please take a look and correct me .

Thanks .

How can I convert if condition into set analysis

Sat, 05 Feb 2011 00:43:57 GMT

Thanks Miguel . I am newbie to qlikview. But I think there is something wrong in my script or declaring dimension.

Please take a look to attachment accepted.qvw and please correct me with explaination.

Thanks.

How can I convert if condition into set analysis

Miguel_Angel_Baeyens — Sat, 05 Feb 2011 11:11:27 GMT

Hello,

The application you posted doesn't have any record with sySchoolStatusID = 5, so no data will be displayed. Besides, your date format should be easier to manage adding in your script

Date(Enrollment.expStartDate) AS Enrollment.expStartDate,

You are qualifying all fields. That will prevent QlikView of associating fields. Did you do that on purpose?

Not having the script nor access to some real or dummy data, it's difficult to go further.

Regards.