Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
skoppe
Contributor II
Contributor II

Split 1 hour record into 4 quarter records

Hi all,

I have a problem, for a report I'm loading certain datavalues per hour:

YearMonthDayTimeDescValue
20136258:00:00testvalue28,31596

I would like this to be 4 quarter (15 minutes) records with the same value, but I don't have a clue how to get this. I guess this must be done while loading in the script. This is the result that I need:

YearMonthDayTimeDescValue
20136258:00:00testvalue28,31596
20136258:15:00testvalue28,31596
20136258:30:00testvalue28,31596
20136258:45:00testvalue28,31596

The difference is in the Time field.

Anyone can help me?

Thanks in advance!

Regards,

Stefan

1 Solution

Accepted Solutions
stephencredmond
Luminary Alumni
Luminary Alumni

Hi,

Create another table that has each "hour" time and each "quarter" time - like this:

Hour, Quarter

08:00:00, 08:00:00

08:00:00, 08:15:00

08:00:00, 08:30:00

08:00:00, 08:45:00

Then left-join that table to your data.  It will now create 4 "rows" for each fact row.

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

View solution in original post

2 Replies
stephencredmond
Luminary Alumni
Luminary Alumni

Hi,

Create another table that has each "hour" time and each "quarter" time - like this:

Hour, Quarter

08:00:00, 08:00:00

08:00:00, 08:15:00

08:00:00, 08:30:00

08:00:00, 08:45:00

Then left-join that table to your data.  It will now create 4 "rows" for each fact row.

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

skoppe
Contributor II
Contributor II
Author

Thanks, I was obviously thinking far too difficult 🙂

Regards,

Stefan