Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to create a filter that determines the following:
If a project has greater than 0 Billable Housr within the last rolling 3 months, then the project is Active
If a project has 0 Billable Hours within the last rolling 3 months, then the project is Inactive
How would I go about this? Do I need to build an Expression that states that if Project Billable Hour is > 0, then 'Active', and if Project Billable Hour is 0, then Inactive.
I'm a pretty novice user so any advice/ direction would be helpful
Create a field in the script when you load the billable hours:
If(InMonths(DateOfWork, Today(), -2), 1, 0) as InLastThreeMonths
Then you could add a summary table with the active projects:
'Active' as Status
InLastThreeMonths = 1