Translate columns into start & end dates

Mon, 16 Dec 2013 20:05:59 GMT

Hi All,

I have a table which looks like this:

Ref No.

Project Name

Start Date - Project

End Date - Project

Jan (2014)

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Q1 2015

Q2 2015

Q3 2015

Q4 2015

Test

01/01/2013

31/03/2014

Test 2

01/05/2015

I have some project data (columns 1 - 4) and some resource data (months) in a table. I need to check if the start and end dates listed mach up with the data in the Jan, Feb etc columns.

So, how best can I scan all of the columns and return the first column that contains a value and the last column that contains a value. Once I have that information then I was thinking a mapping table would be the best way to return a date...?

Thanks!

Re: Translate columns into start & end dates

Mon, 16 Dec 2013 21:29:09 GMT

Hello,

I'm not sure if I understand but attach an example:

Best Regards.

topic Translate columns into start & end dates in QlikView

Translate columns into start & end dates

Re: Translate columns into start & end dates