Discussion board where members can get started with Qlik Sense.
So the story goes like this,
Initially, this "Ceil(MonthEnd(Max(Date(dateSet))) - MonthStart(Min(Date(dateSet))))" would do. It works for calculating the total number of days from August to October. However, the requirement changed, how can I get the total number of days only for the selected months? I couldn't find a way. Please help.
I tried with this script:
LOAD *, Makedate(Year, Month) as YearMonth
Item, Sales, Year, Month
And returns 59 in all rows (31 days of january + 28 of february)
Something must be different, can you upload the sample with the YearMonth field created?
hi you can do it by using this expression
sum(aggr(Ceil(MonthEnd(Max(Date(dateSet))) - MonthStart(Min(Date(dateSet)))),MonthName))
but then in each month you lose one day so what i'll use is
Still returning zero,
dateSet is a set of dates from 2 sources ( 2 excel files)
Then in my app i did it like this. However I did not add it to the table's dimension. Not sure will that affect the expression.
when i put the dimension in the aggr function as "dateSet", only then numbers will be displayed, but the result is wrong.
Tried "=Sum(Aggr(Day(MonthEnd(Max(dateSet))), MonthField)) " too. It's not usable in my scenario.
Below are the sources and app.
The problem lies in when the user select the Month Oct 2015 and August 2015. How do I get 31+30 only? Rather than 31+31+30 as number of days.