Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a problem, for a report I'm loading certain datavalues per hour:
Year | Month | Day | Time | Desc | Value |
2013 | 6 | 25 | 8:00:00 | testvalue | 28,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:
Year | Month | Day | Time | Desc | Value |
2013 | 6 | 25 | 8:00:00 | testvalue | 28,31596 |
2013 | 6 | 25 | 8:15:00 | testvalue | 28,31596 |
2013 | 6 | 25 | 8:30:00 | testvalue | 28,31596 |
2013 | 6 | 25 | 8:45:00 | testvalue | 28,31596 |
The difference is in the Time field.
Anyone can help me?
Thanks in advance!
Regards,
Stefan
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
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
Thanks, I was obviously thinking far too difficult 🙂
Regards,
Stefan