Discussion Board for collaboration on QlikView Scripting.
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
Please give more details. May you show more rows of your source table data and how those rows should look like after transformation?