topic Re: Set Analysis in QlikView

Set Analysis

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

Hello,

I have the data like this. Here I'm calculating the %Over time. = OverTime_Hrs/PlannedHrs

Now I'm trying to calculate the Number of staff who worked in between >= 10.1 to <=15% in a text box. Please advise.

sunny_talwar — Tue, 27 Sep 2016 20:02:23 GMT

May be like this:

Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)

rupamjyotidas — Tue, 27 Sep 2016 20:10:55 GMT

Something like this

=Count({<%Overtime = {">=10.1 and <=15"}>} EMPLOYEE_ID)

Script:

Fri, 30 Sep 2016 00:26:16 GMT

hi das

{">=10.1 and <=15"}>}

do you think the 'and' is mandatory

rupamjyotidas — Fri, 30 Sep 2016 15:56:25 GMT

{">=10.1<=15"}>}

Should do the trick