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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Partner - Creator II
Partner - Creator II

How to find total production days..

Hi,

I am new in qlikview. for my company i need to calculate total working days. but here have six plants in which 2 is six days working, 3 is 7 days working and 1 is 5 days working. Please suggest me how to calculate the no of working days for each plant.

1 Reply
swuehl
MVP
MVP

If you are using a master calendar, you can add working days flags for each plant, then sum the working days like

=Sum( Rangesum(PlantAFlag, PlantBFlag, PlantCFlag))

The sum will automatically consider your current calendar date selection.

Adding working days flag to a master calendar allows you to support very different scenarios, plant or public holidays etc.