Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with import of a excel

Hi

Can someone maybe help me out here and show me how I best import attaced excel.

I don´t get how I should do with the diffrent headers.

edit: the +/- don´t have to be imported, I will have qv to do that any way

/thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Problem with import of a excel

See attached qvw, adapted for the complete set of months.


talk is cheap, supply exceeds demand
4 Replies
vgutkovsky
Not applicable

Re: Problem with import of a excel

You will need to crosstab it and then apply some additional transformations. See attached QVW.

Regards,

Vlad

Not applicable

Re: Problem with import of a excel

Thanks. Can´t reaaly get the 2nd and 3d step so i´t did´t work out on my complete sheet. I reattace the file with the complete data. Do you think you can help me again or tell me why it get wrong with the f12 header and higher.

Gysbert_Wassenaar
Not applicable

Re: Problem with import of a excel

See attached qvw, adapted for the complete set of months.


talk is cheap, supply exceeds demand
Not applicable

Re: Problem with import of a excel

Thanks!