Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks!