Load / transform dates

[stuartfrew]

Hey folks,

Is there any way to load/transform this data so that i can get actual dates to use. Company firewall wont let me upload a sample excel 😕

So many issues here, cells are just coloured with no values in them, structure of the columns dont really help either. 

Can Qlikview work its magic though>?

[rwunderlich]

I think it would be possible to load something like that -- the information is there. It's hard to offer specifics without a sample file. You would probably use some variation of CrossTable load.

-Rob

[marcus_sommer]

It looked as if you might create a gantt-chart in Qlik or to adapt at least some ideas/approaches from it - here an example: How to create a Gantt chart using a Pivot table - Qlik Community - 610365

Further - don't try to replicate your Excel 1:1 in Qlik especially the layout else try to transfer the essential information and I wouldn't be surprised if you could add much more value as if it would possible in Excel.

- Marcus