Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with my data. It has the following structure
Name | Timestamp | no of |
K1 | 2013-09-01 03:00:00.000 | 6 |
K1 | 2013-09-01 04:00:00.000 | 5 |
the problem is that the given hour is wrong; it should be 02.00 instead of 03.00. All "no of" needs to be moved "up"
Is there an easy way to fix this i qlikview?
I thought about some sort of if-statement at first, but it got complicated since there was a lot of special cases.
I have about 35 excel files with the same kind of structure. I thought about writing a macro in excel and fix the problem there instead
At the moment I'm using Hour(Timestamp) to get the hour from the timestamp filed
Hi Anna,
Please give more details. May you show more rows of your source table data and how those rows should look like after transformation?
regards
Darek