Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
akpofureenughwu
Contributor III

Date Creation

Good day everyone. I need help. I need to create date from a field as shown from the attached file. How do I get date, month, quarter from the date availabe in the attached file. Please assist me? Thanks

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Date Creation

See if the attached make sense

View solution in original post

4 Replies
Highlighted

Re: Date Creation

I think it would be best if you use CrossTable load to change the MonthYear into rows. Look here on how to do it:

The Crosstable Load

Once you do this, all manipulations will be very easy

Highlighted
akpofureenughwu
Contributor III

Re: Date Creation

Cool but can u help me to cross a set of data as a sample for me to execute others. Pls see the attached excel file. Thanks man

Highlighted

Re: Date Creation

See if the attached make sense

View solution in original post

Highlighted
akpofureenughwu
Contributor III

Re: Date Creation

Bravo sir, But can you help me with the day as a field please so I can drill from year to quarter to month to day. Thanks so far man