Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Networkdays function impacted by chart dimension

Hi,

I'm having trouble with a bar chart that has 2 dims and a measure that includes a networkdays calculation.

Please see attached file and filter on Mth-Yr='Oct-17' and callsign='NEWT21'.  The table next to the chart has the correct average calculation (10.0) , but the chart does not calculate this measure correctly (11.15), although it uses the same formula.

The reason is Dim 'DHB' , value='ACC' has only only 1 weekday available for selection, due to very few data rows compared to multiple for the other DHB values.

So what I'm after is a way of dividing by networking days in the chart measure - for the user selected Mth-Yr's , but ignoring the dimension DHB - to get the same average value as per the table.

I have tried using the TOTAL function but with no success.

many thanks

Gus

1 Solution

Accepted Solutions
Highlighted

Re: Networkdays function impacted by chart dimension

May be try this

Count(DISTINCT Ref_Number)/NetWorkDays(Min(TOTAL <Callsign> Date1), Max(TOTAL <Callsign> Date1))


Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Networkdays function impacted by chart dimension

May be try this

Count(DISTINCT Ref_Number)/NetWorkDays(Min(TOTAL <Callsign> Date1), Max(TOTAL <Callsign> Date1))


Capture.PNG

View solution in original post

Highlighted
New Contributor III

Re: Networkdays function impacted by chart dimension

thank you so much Sunny, that works a treat !!