topic Re: Problem in multi selections in years in QlikView

Problem in multi selections in years

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

I want display worked hours per EMP_ID month wise , year wise and multi selection of months and years alone.

employee worked hours enter daily basis

here condition is worked hours <4 is available,>=4&<8 is partially available,>=8 is occupied.

could you please tell me script level

Regards

Yuvaraj

MK9885 — Wed, 18 Jan 2017 16:29:46 GMT

Simply add

Month and Year to your Multi Box chart

User can select single month or multiple..

And the data will change according to the user selection.

Is this what you need?

vishsaggi — Wed, 18 Jan 2017 17:09:31 GMT

What is your expected output, you want a new field to display if an employee available or occupied based on worked hours? IF Yes,

Then in your script write like

LOAD *,

IF(WorkedHours < 4, 'Available', IF(WorkedHours >= 4 AND WorkedHours < 8, 'Partially Available',

IF(WorkedHours >= 8, 'Occupied'))) AS Availability,

Year(Sheetdate) AS Year,

Month(Sheetdate) AS Month;

LOAD EMPID,

WorkedHours,

Sheetdate

FROM

[WorkedHours.xlsx]

(ooxml, embedded labels, table is Sheet1);

Let us know if this is what you are looking for.