This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need some help if any can help me out how to write the formula here.
So i have a simple 3 columns excel to be import into Qlik Sense.
My column 1 is the Month/Date/Year
My column 2 is sum of count for each Month/Date/Year.
I want my column 3 to do the following.
The average count of column 2 based on workdays. For example, on 6/1/2019, i have total sum of 1078 counts. In June 2019 - there is 20 working days. So it would be 1078/20 = 53.9
Then for 5/1/2019, i have 1242 counts. Working month for 5/1/2019 would be 22 workdays = 1242/22 = 56.4545
So each month will calculate what their workdays are divided by the sum of count on column 2.
How do i do this?
NetWorkDays() - for example:
=Sum(<count field>) / NetWorkDays(MonthStart(<date field>), MontheEnd(<date field>))
(replace the placeholders with the correct field names)