Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

convert weekday to a date

Hi,

I have a list of articles and weekdays they arrive.

Example:

ArticleArrivalDay 1ArrivalDay 2
Article1MondayFriday
Article2WedensdayFriday
Article3MondayTuesday
Article4TuesdayThursday

Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain

Anyway, result that I want is this:

ArticleArrivalDate 1Arrival Date 2
Article125-03-201322-03-2013
Article220-03-201322-03-2013
Article325-03-201326-03-2013
Article426-03-201328-03-2013

Any help is appreciated

thanks in advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: convert weekday to a date

See attached example


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: convert weekday to a date

See attached example


talk is cheap, supply exceeds demand
Not applicable

Re: convert weekday to a date

Thanks you so much, that´s awesome!

I haven´t really figured out how it works yet but hopefully I will