topic Re: How to filter the Training in QlikView

How to filter the Training

alvinford — Tue, 29 Dec 2015 14:52:44 GMT

Hi All,

Trying to get the following logic. I have the following details in table

i.e. Teacher ID, Teaching Code, Status , Start Date and End Date.

I want to exclude the Teacher ID's who are in Training (teaching Code A16,A17,A18) when the Year or

Month of Teaching period falls in between the Start Date and End Date is selected.

For Example : If Year 2013 and Month 4 is selected, distinct count(Teacher ID) should be 4. i.e. Teacher ID 50440 and 54240 and 53080 to be excluded from the distinct count of Teacher ID as they are in the training.

For Example: If Year 2014 and Month 11 is selected , distinct count(Teacher ID) should be 6 i.e. Teacher ID 53080 will be excluded as from the distinct count as he is in Training for that selected period.

Would like to achieve this logic from the backend i.e. at Script

Please find the attachment for your reference.

Regards,

Alvin.

Message was edited by: alvinford ford

Re: How to filter the Training

petter — Tue, 29 Dec 2015 16:26:51 GMT

Wouldn't also 53080 be "In training"? As row #3 claims so...

I am not sure that I understand your logic...Could you please explain more?

Re: How to filter the Training

petter — Tue, 29 Dec 2015 16:54:47 GMT

This might be what you are looking for - but you don't need or probably would have a problem implementing this in a "Load Script". I have a solution that use the Set Expression and Excluded element function to achieve the logic that I think you are looking for:

Re: How to filter the Training

Kushal_Chawda — Tue, 29 Dec 2015 17:05:32 GMT

what would be the Count of ID when date 4/1/2013 is selected?

Re: How to filter the Training

alvinford — Tue, 29 Dec 2015 23:09:55 GMT

Hi Peter ,

You are right. 53080 will also be excluded when Year 2013 and Month 4 is selected.

As I mentioned earlier, would like to achieve this logic in the script.

Regards,

Alvin.

Re: How to filter the Training

alvinford — Wed, 30 Dec 2015 05:57:47 GMT

Hi ,

Any help is aprreciated..

Regards,

Alvin.