topic Re: Data aggregation in QlikView

Data aggregation

Anonymous — Wed, 23 May 2018 09:12:10 GMT

Hi guys,

I have a list of records related to employees where I have the admission date (DD-MM-YYYY). I need to create a report where I can summarise the number of employees that I have in the company with more than 4 years, the ones that I have between 2 and 4 years and also the ones that I have until two years. What is the best option to do this?

Re: Data aggregation

dwforest — Wed, 23 May 2018 20:55:52 GMT

I'd construct a table to define the brackets

You could script as:

LOAD

[YOS Bracket], YOS;

LOAD

[YOS Bracket],

Start+IterNo() as YOS,

Start,

End;

LOAD * INLINE [

[YOS Bracket], Start, End

'0-2',0,2

'2-4',3,4

'5+',5,99

;

Then for each employee calcuate a YOS field.