My First post on Dates and how it will work in Qlik

[#1]

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 ....

http://community.qlik.com/message/398646#398646

[its_anandrjs]

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

[Colin-Albert]

This post is a good start on how dates work in QlikViewGet the Dates Rightt

[maxgro]

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

QlikView Date fields

Get the Dates Right

[ecolomer]

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)

[#6]

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

[maxgro]

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)