topic Re: Load / transform dates in App Development

Load / transform dates

stuartfrew — Fri, 24 Jun 2022 14:21:50 GMT

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>?

Re: Load / transform dates

rwunderlich — Fri, 24 Jun 2022 16:05:19 GMT

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

Re: Load / transform dates

marcus_sommer — Mon, 27 Jun 2022 11:31:16 GMT

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