Dynamic record set

[riccardo_schiav]

Hi folks,

I'm trying to add an expression to a pivot table in Qlikview calculating the sum of employees' performance of their current individual 90 days intervall starting from their respective entry date.

I have formatted Date and EntryDate as numerics in the script but it still yields 0 for all rows:

sum({<Date={">=$(=EntryDate+(Floor((num(Today())-EntryDate)/90)*90)))"} , Category={'A'}>}MinPerformed)

Any suggestions?

Thanks in advance.

Riccardo

[riccardo_schiav · Accepted solution]

Obviously had to create a flag in the script since every employee has a different entry date.