Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yucel_ozer
New Contributor II

Counting the number of selected days as standard value.

Dear Friends,

I have month selected and the number of total days of April is 14  as used/filled days is 14 for  April.

I want to calculate measure (Y axis) / dimension (X axis)  by using the number of days,30 ( the number of days of April), not 14.

So, when I select 2 months or 1 year, the number of days should be added as a total number of selected days. (For example, when March and April selected, the result should be : 31+30 =61, And I need the value of "(Y axis) / (X axis)"

Could you please help me about the correct script on that.

I already used the master calender but the result remains same, the real number of days is14 for April.

Thanks and regards.

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: Counting the number of selected days as standard value.

Something like, if Date is your date field

MonthEnd(Max(Date)) - MonthStart(Min(Date))

4 Replies
mov
Esteemed Contributor III

Re: Counting the number of selected days as standard value.

You're not getting any responses because it is not clear what you're doing and what the problem is.  It will be helpful if you can upload your application.
Meanwhile, just a guess (could be wrong) - look into the "Add-On" in chart properties, go to "Data Handling", and check the box "Include zero values" if it is not checked.

yucel_ozer
New Contributor II

Re: Counting the number of selected days as standard value.

I will give you an example : :

By the way, I have already checked there is no data handling check box issue.

I am selecting a month, April as dimension, There are jonly total 14 dates in the database for April...

I want to calculate daily rate ( My Measure / the number of days). This means the number of days will be 30 for April (not 14)

When I choose more than a month, this total number will be added (For example if I select Apr and May, the number of days will be 30+31=61. This means, daily rate formula = My Measure / 61

I hope that explanation makes myself clear.

Thanks in advance.

dwforest
Valued Contributor

Re: Counting the number of selected days as standard value.

Something like, if Date is your date field

MonthEnd(Max(Date)) - MonthStart(Min(Date))

yucel_ozer
New Contributor II

Re: Counting the number of selected days as standard value.

I dont believe that the correct script could not be so basic.

I have tried to use several codes, set analysis, master calendar etc.

Thank you David.

Community Browser