Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,this is my first post on Qlik expecting solutions.Trying self learn with qlik previously have BI/DW background In QlikView how dates will work i have a column Period which has 'YYYYMM' format dates as '201408'.how can i write date function on it to get each month start and end date for that period using make date function to get month and year
Why i need is because with knowing month and year i can learn how to work with splitting monthly qvd,quarterly qvd,yearly ....
Hi,
In the load script you can try this with MonthStart and MonthEnd functions.
Load
Period,
MonthStart( Period ) as PeriodMonthStart,
MonthEnd( Period ) as PeriodMonthEnd
From Source;
Regards,
Anand
This post is a good start on how dates work in QlikViewGet the Dates Rightt
for month start
=date(date#('201408', 'YYYYMM'))
for month end
=date(floor(MonthEnd(date#('201408', 'YYYYMM'))))
or if you want to use makedate for start
=makedate(left('201408',4), Right('201408',2))
I suggest to read
You can use
MonthStart(Date) for the first date in the Month and
MontEnd(Date) for the last date in the Month
And you have an example (fiel QVW)
Thanx for quick solutions i'm posting some data and qvw
For my POC got Requirement like as follows
step 1:Loading whole data and storing in QVD
Step 2: on Existing QVD need to write date functions to Period column as make Date fun and associate month start and month end on clicking Period column.(Sales_Shippers_Qvd_Dates.qvw)
Step 2.1:On QVD need to write logic of splitting Main Qvd into Yearly.qvd and Quarterly.qvd
can any help on how to write logic of Sales_Shippers_Qvd_Dates.qvw to have right association splitting if Yearly,Quarterly.qvd
I got this scenario Main QVD will have All years of Data again in seperately need to have Yearly,Quarterly.qvd while using main qvd
see attachment
it's a .qvw with (I hope) answer to all your req (store qvd, month start/end, split qvd in year and quarter)