Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
QS21
Creator
Creator

Uploading merged headers

20210708_072054.jpg

 Hi,

I have an excel format like this from which I only need the data highlighted in orange.  Kindly help.

4 Replies
avinashelite

As per my knowledge Qilk can't read the color format and load the data from Excel .

Share the sample data set we will try to check any other workarounds 

QS21
Creator
Creator
Author

Hi, sorry my bad. I doin't mean to pick data based in color. I am just letting yiu know which details I need from the above excel. When I transposed the table in Qlik, I am only getting "H1" under Jan and Feb but not H2 and total. How do I get those details as well?

avinashelite

Oh okay , could you please share the sample file and the code so that we could check what is the issue with code 

QS21
Creator
Creator
Author

Hi Attached the sample data, sorry that I don't have proper code to share.