Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to load a column that has a
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 | 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
Hi Cedric - just making sure - are you using QlikView and not Qlik Sense? If so I will move this over to the appropriate forum.
Mike
I am using Qlikview, apologize for mixup.
Actually, I was able to figure it out.
I multiplied the LOAD by 24.
Thank you. please remove/delete if necessary