topic Re: List box exporting to excel issue in QlikView

List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 07:29:30 GMT

Hi all,

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

Kindly advise.

Regards,

Mahamed

Re: List box exporting to excel issue

Anonymous — Fri, 03 Jun 2016 07:39:29 GMT

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

Re: List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 09:06:57 GMT

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

Re: List box exporting to excel issue

mightyqlikers — Fri, 03 Jun 2016 09:15:30 GMT

share your sample qvw.

$@M

Re: List box exporting to excel issue

Anonymous — Fri, 03 Jun 2016 09:33:04 GMT

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

Re: List box exporting to excel issue

Anil_Babu_Samineni — Fri, 03 Jun 2016 09:33:16 GMT

Khan,

Can you please share me your workfile ...

Re: List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 10:36:44 GMT

Hi Manuel

Yes, I was using ARGB for caption backgroud.

Regards,

Mahamed

Re: List box exporting to excel issue

Anonymous — Fri, 03 Jun 2016 10:42:17 GMT

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!

Re: List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 11:05:12 GMT

Here is the attachement

Re: List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 11:06:11 GMT

Hi Manuel,

Please find the attached qvw.

Re: List box exporting to excel issue

Anonymous — Fri, 03 Jun 2016 11:16:55 GMT

I think that issue is because you have conditional expressions, with conditionat visualization object is working, see attached on DashBoard sheet.

Kind regards.

Re: List box exporting to excel issue

Mahamed_Qlik — Fri, 03 Jun 2016 11:33:52 GMT

Hi Anil,

Please check the attachment

Re: List box exporting to excel issue

Mahamed_Qlik — Mon, 06 Jun 2016 08:46:36 GMT

Hi Anil,

Any update?

Re: List box exporting to excel issue

Mahamed_Qlik — Mon, 06 Jun 2016 08:46:52 GMT

Hi Sam,

Any Update?

Re: List box exporting to excel issue

Mahamed_Qlik — Mon, 06 Jun 2016 08:47:40 GMT

Hi Manuel,

Did you checked the attached .qvw ?

M waiting for your feedback.

Regards,

Mahamed

Re: List box exporting to excel issue

Anonymous — Tue, 07 Jun 2016 06:56:38 GMT

Hi Mahamed,

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

Kind regards

Re: List box exporting to excel issue

Mahamed_Qlik — Tue, 07 Jun 2016 07:55:43 GMT

Hi Manuel,

This is working, but Looking into the application, I am not able to see what exactly changes u made.

Can you please help me with that?

Regards,

Mahamed

Re: List box exporting to excel issue

Anonymous — Tue, 07 Jun 2016 08:04:30 GMT

Hi Mahamed,

I have deleted your object, and I have created one object for each expression, and I hide each object with your conditional expressions.

The problem was the conditional expressions. You can do by this way, or doing only one expression with Pick or If.

Kind regards.

Re: List box exporting to excel issue

Mahamed_Qlik — Tue, 07 Jun 2016 11:04:02 GMT

Hey Manuel,

Thank you so much for your kind help.

Regards,

Mahamed

Re: List box exporting to excel issue

Mahamed_Qlik — Wed, 08 Jun 2016 07:02:29 GMT

Hi Manuel,

Today, Morning I gor this issue again.

The same issue persisting while exporting from access point and

works fine with desktop.

Please advise.

Regards,

Mahamed