Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Latest date per employee per indicator

Hi there,

Trying to make an overview for holidays per employee. Running into the following problem:

Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.

As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type.

How can I do this?

Best regards,

Marco

Holiday overview.png

3 Replies
IAMDV
Honored Contributor II

Latest date per employee per indicator

Hi Marco,

Sorry, this is confusing. Please can you post the QV document?

Thanks - DV

Not applicable

Re: Latest date per employee per indicator

No probleem.. please find attached.

All test data but scrambled it anyway... thanks.

Best regards,

Marco

michielvandegoo
Valued Contributor

Latest date per employee per indicator

Well I hope this is all fake test data. Otherwise you just posted some personal data.

Use the scramble option (Document Properties - Scrambling) to scramble personal data (like names).

Community Browser