Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I filter out weeks with holidays or days off

Hi, I have a simple bar graph. For the Dimension, I have WeekYear and for the measure, I have sum(Sales).

My question is simple. How do I remove weeks with less than 5 days? I would essentially count the number of days where sales>0 and ignore the weeks where the count of days is <5.

Thanks.

0 Replies