Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
vgutkovsky
Master II
Master II

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

Regards,

Vlad

Not applicable
Author

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

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


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks!