Dynamic record set

riccardo_schiav — Wed, 25 Jul 2018 14:00:11 GMT

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

Re: Dynamic record set

riccardo_schiav — Fri, 03 Aug 2018 07:12:05 GMT

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

topic Dynamic record set in QlikView

Dynamic record set

Re: Dynamic record set