Discussion board where members can get started with Qlik Sense.
I need to have custom monthstart and monthend Is this posible?
It completely depends on the week. Our week starts on Monday and ends on Sunday.
If the week starts on end of last month and ends on present month, Then the monthstart date is that weekstart date for the current month.
And if monthend date will be checked on same basis it should be the last weekend date.
1) October month : from sep 28th to Oct 25th.
2) November month : from oct 26th to Nov 29th.
3) December month : from Nov 30th to Dec 27th.
Yes, you can..
What I would suggest, define a Inline function or a table in your database, like:
Load * inline
[Year, Month, MonthStart, MonthEnd
2015, Oct, 28th Sep 2015, 25th Oct 2015
2015, Nov, 26th Oct 2015, 29th Nov 2015
and so on..
Map this table into your data model, use intervalmatch of your tranxn date with this inline defined....
You will get what you want.
Inline functions gives the date what we have hardcoded. please correct me if i wrong.
I will create a table like you explained.
Then i need to enter all the start dates and end dates ii don't Want like that, It should create dynamically.
Is their any way to find the number of weekends in a month?
Number of sundays in a month?
Agreed, but no other solution
For number of sunday, you can try weekday(),Returns an integer between 0-6
like at script you can write like:
If(weekday(DateField)=6,'1','0') as SundayRecordCounter //
and then simply write =sum(SundayRecordCounter)
Read this blog post: Redefining the Week Start
Try this sample script
Month(WeekEnd(Date)) AS Month;
Date(YearStart(Today()) + RecNo()) AS Date
Year(WeekEnd(Date)) AS Year,
Date(YearStart(Today()) + RecNo()-1) AS Date
need the weekend count of current month?