I have a problem with my data. It has the following structure
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