Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which is returning all Timecard_ids where the following is true:
OTL_FLAG = '1'and Sum(TOTAL<[Employee Number],[OTL Start Time]> [OTL Hours Entered]) >=$(vL.WeeklyHours)
$(vL.WeeklyHours) is a variable containing a number as default but which can be updated by the user using the Variable Input chart in the Qlik Dacount if conditionshboard bundle.
I am now trying to produce a KPI to show a count of the timecard_ids returned in the table and therefore meet the above conditions but I am not able to get the count syntax correct.
I would be grateful for any help.
As below
=Count({<
[Employee Number]={"=Sum(TOTAL<[Employee Number],[OTL Start Time]> [OTL Hours Entered]) >=$(vL.WeeklyHours)"}, OTL_FLAG={'1'}
>}Distinct [Employee Number])
Hi,
Thanks for the response. I have tried what you suggested but it is not working. If I select using one specific [OTL Start Time} and OTL_FLAG = 1 then the count does work but without these selections it is returning too many records.
Do you have any further suggestions?
Thanks
Is not just using the incorrect fields.
=Count({<
[Employee Number]={"=Sum(TOTAL<[Employee Number],[OTL Start Time]> [OTL Hours Entered]) >=$(vL.WeeklyHours)"}, OTL_FLAG={'1'}
>}Distinct Timecard_ids)