Uploading merged headers - Qlik Community

QS21 · ‎2021-07-07

Hi,

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

avinashelite · ‎2021-07-07

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 · ‎2021-07-08

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 · ‎2021-07-08

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

QS21 · ‎2021-07-08

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