I am trying to load a column that has a format - (Hour format)
Excel displays it as normal integers,
1 to 500 hours
However, Qlikview reads it as the "value" format (back end format prior to the hour conversion)
For example:
| Hours as displayed in excel | Data (values) read by Qlikview |
| 28 | 1.166667 |
| 18 | 0.75 |
| 25 | 1.041667 |
| 25 | 1.041667 |
| 26 | 1.083333 |
| 24 | 1 |
| 23 | 0.958333 |
| 18 | 0.75 |
| 6 | 0.25 |
| 6 | 0.25 |
| 7 | 0.291667 |
| 5 | 0.208333 |
Is there anyway I can load what is being displayed?
I know this might be unclear, please paste the right column into excel and format cells as custom. Type .
Thanks in advance
