Solved: List box exporting to excel issue - Qlik Community

Mahamed_Qlik · ‎2016-06-03

Hi all,

While exporting list box to excel, i am getting following as per screenshot.

Kindly advise.

Regards,

Mahamed

Anonymous · ‎2016-06-07

Hi Mahamed,

Look at my answer on 03-jun-2016 13:16.

Kind regards

View solution in original post

Anonymous · ‎2016-06-03

Hi Mahamed,

Have you used Alpha colour on your list box?

Alpha colour are not exported with transparency to Excel, because Excel have not this option.

Regards

Mahamed_Qlik · ‎2016-06-03

Hi Mauael,

Thank yor for your advise. How to check whether alpha color has been applied or not ?

If yes, then can you please let me know how to fix this?

Regards,

Mahamed

mightyqlikers · ‎2016-06-03

share your sample qvw.

$@M

Anonymous · ‎2016-06-03

Hi mahamed, do you have expresions line ARGB or LightGray(n)?

Anil_Babu_Samineni · ‎2016-06-03

Khan,

Can you please share me your workfile ...

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Mahamed_Qlik · ‎2016-06-03

Hi Manuel

Yes, I was using ARGB for caption backgroud.

Regards,

Mahamed

Anonymous · ‎2016-06-03

Ok,

ARGB funcion has 4 parameters: Alpha, Red, Green, Blue.

Firts parameter is nor understanding by Excel, use RGB with a gray colour for background caption.

King regards!

Mahamed_Qlik · ‎2016-06-03

Hi

Here is the attachement

Mahamed_Qlik · ‎2016-06-03

Hi Manuel,

Please find the attached qvw.