Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
stephen-a_redmo
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
stephen-a_redmo
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

skoppe
Contributor II
Contributor II
Author

Thanks, I was obviously thinking far too difficult 🙂

Regards,

Stefan