Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignore filters for Networkdays calculation

I've looked around and seen several solutions for creating a static calculation on a field that is subject to filters, but my use case seems to be sufficiently different.

I am working on a daily report with a table that looks like this:

EmployeeDays Since Last Phone CallDays Worked
Gianna

5

4

Harold25
Tyler35

This report has a filter that allows users to select a number of weeks. The Days Worked column should be dynamic and show the number of days worked for the selected time period. However, I would like the Days Since Last Phone Call column to always show the number of days since the last call relative to today. Currently, it does so only when no filter is selected.

The code I am using for the Days Since Last Phone Call column is this:

Networkdays(Max(PhoneCallDate), Today() - 1)

I have seen several discussions that mention using set analysis, but I am not doing a count or sum so it does not appear to be applicable. I also cannot use TOTAL as I need the days to be per employee, not a whole.

1 Solution

Accepted Solutions
sunny_talwar

Try this

Networkdays(Max({1} PhoneCallDate), Today() - 1)

View solution in original post

1 Reply
sunny_talwar

Try this

Networkdays(Max({1} PhoneCallDate), Today() - 1)