Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
erieqlik
Contributor II
Contributor II

I have a data set that contains dates as separate records. I want them collapsed to one record with all the dates

I have a data set (table) with the following columns:

Story, backlog_date, approved_date, inprogress_date, completed_date

The way it is assembled it has repeated rows for each story, I want to collapse the data to just a single line. Not all stories have values for the dates, i.e. is its not completed then there will be no row with a completed date. Below is a example of the data (what I have and what I want). 

Example 3.jpg

I want to have a table that resembles the Result

Labels (2)
1 Solution

Accepted Solutions
erieqlik
Contributor II
Contributor II
Author

ChatGPT said to do this, it seemed to work.

Collapsed:
Load
Story,
FirstSortedValue(backlog_date, backlog_date) as backlog_date,
FirstSortedValue(approved_date, approved_date) as approved_date,
FirstSortedValue(inprogress_date, inprogress_date) as inprogress_date,
FirstSortedValue(completed_date, completed_date) as completed_date
Resident starting_data_set
Group by Story;

View solution in original post

1 Reply
erieqlik
Contributor II
Contributor II
Author

ChatGPT said to do this, it seemed to work.

Collapsed:
Load
Story,
FirstSortedValue(backlog_date, backlog_date) as backlog_date,
FirstSortedValue(approved_date, approved_date) as approved_date,
FirstSortedValue(inprogress_date, inprogress_date) as inprogress_date,
FirstSortedValue(completed_date, completed_date) as completed_date
Resident starting_data_set
Group by Story;