topic Re: expression help in QlikView

expression help

abhaysingh — Mon, 29 Sep 2014 06:55:34 GMT

I want to show number of days for condition

if( IN_TIME > GraceTime ) and Attendance_status = 'P' and 'POW' than it shud give me number of days.

please help me to write it in set analysis.

Re: expression help

sasikanth — Mon, 29 Sep 2014 06:58:39 GMT

Try some thing like below

count({<Attendance_status = {'P' , 'POW'}>}if( IN_TIME > GraceTime,days))

Re: expression help

PrashantSangle — Mon, 29 Sep 2014 07:00:09 GMT

Hi,

Try like this

Count(if(Wildmatch(Attendance_status,'P','POW') and IN_TIME>GraceTime,NoOfDays)

if you want distinct No of Days then write

Count(if(Wildmatch(Attendance_status,'P','POW') and IN_TIME>GraceTime,Distinct NoOfDays)

Need Sum write Sum instead of Count.

Count({<Attendance_status={"P","POW"},IN_TIME={">$(=GraceTime)"}>} NoOfDays)

Regards

Re: expression help

Mon, 29 Sep 2014 07:06:36 GMT

Dear Abhay,

There are two ways:-

1. count({$<Attendance_status= {'P' , 'POW')},IN_TIME={">=$(GraceTime)"}>}days)

2. If(IN_TIME>GraceTime,(count({$<Attendance_status= {'P' , 'POW')}days))

Thanks &Regards

Prince Anand

Re: expression help

Mon, 29 Sep 2014 07:07:09 GMT

Use the expression as Max suggested but

Remember the fields IN_TIME and GraceTime must be of same date format.

You can convert them into numbers in script level and also use them to avoid confusion.

Thanks,

Singh

Re: expression help

Mon, 29 Sep 2014 07:08:31 GMT

Hi,

You Can Use the following Exp. :

Count({<IN_TIME={">$(=GraceTime)"},Attendance_status={'P','POW'}>} NoOfDays).

Regards,

Saurabh

Re: expression help

Anonymous — Mon, 29 Sep 2014 07:49:59 GMT

Both expression are not working

Re: expression help

Mon, 29 Sep 2014 08:33:15 GMT

Dear Abhay,

Please check the attached app.

Thanks & Regards

Prince Anand

Re: expression help

Anonymous — Mon, 29 Sep 2014 08:37:37 GMT

Anand,

Here INtime is like 08:30:00 similar to ShiftStartTime not numeric.

Re: Re: expression help

Mon, 29 Sep 2014 08:49:52 GMT

Dear Abhay,

Please check the attached app.

Thanks & Regards

Prince Anand