Calendar Fixed Days

[Anonymous]

(Count(TOTAL distinct([CREATED_DT.autoCalendar.Date])))*.75

the above expression works on all aggregates as long as not filtered by a specific subset category. It is designed to calculate the dates that sales occurred on.

in my source file, there is no 'null' values or rows for weeks with no business.

What I am trying to do is have Qlik calculate the total number of available days during the period from the beginning of fiscal year(0ctober 27 2017), so I can measure a sales reps productivity  by how many days they submitted sales in the available total days, so 'days with sales, divided by total available days to sell in"

the .75 is to allow for two days per week off such as a weekend etc. so 5 eligible days so to speak per week.

The issue is when I filter by a subcategory say "supervisor is stock" the total number of days changes, it should be constant.

any help appreciated to tell qlik to not change total number of available days? Follow up question is, can I tell qlik which date is the start of the fiscal year?

thanks so much qlik community!

[Anonymous]

its only considering a day to exist if a sale(created date) existed on that date,

[Anonymous]

That works as well, Thanks

I think I've isolated the issue, teh source file(excel) does not have rows with 0 values for days where no sales happened.

When I choose my whole business obviously have sales every day(created date) so it gives the right total number of days because there are no 0 values.

when I filter by the supervisor the above solutions work provided but the number still changes, reason being, a small team of reps have days where they had no sales so Qlik is only counting day with sales(created date). There are no rows with 0 values for days with no sales.

this is the issue

so a new question: is there a way to add a calendar to qliksense so I can simply count days between a period? ignoring my source file which is only creating calendar dates for days there were sales.

Thanks

[luismadriz]

Hi Ken,

I created this subprocess to create master calendars. I hope it helps

My 2 cents on Time Analysis

Cheers,

Luis