topic Re: need decimal values in Excel in QlikView

need decimal values in Excel

Mon, 12 Nov 2012 16:59:03 GMT

Hi,

I got new requirement in my project, I have a pivot table in my dashboard i want to show the values without decimals in my pivot table.

But when i export or copy that object into excel i want display the decimals in excel.

Where can i change the setings,

can anyone know the solution about this.

regards,

baru

Mon, 12 Nov 2012 17:01:46 GMT

I don't know of any easier way to do it, but you can use a macro to export it to Excel and set the format however you want.

Mon, 12 Nov 2012 17:25:14 GMT

Hi Rebeccad,

Thanks for your reply,

Can you please tell me how to write the macro for this one.

regards,

baru

Mon, 12 Nov 2012 17:40:50 GMT

See attached. Make sure you set the following security settings for it to work:

On Opening (if applicable):

Under Edit Module:

Mon, 12 Nov 2012 17:41:54 GMT

Oh hang on - I just noticed it is converting the integer. I will adjust the macro and reload the test file for ya. One sec.

Mon, 12 Nov 2012 18:02:33 GMT

Okay, here you go. Hope it helps!

Tue, 13 Nov 2012 14:55:46 GMT

Thankyou rebeccad,

its working charm,

sorry to late for mark as correct answer.

regards,

baru

Anonymous — Sun, 29 Mar 2015 00:08:51 GMT

Hi Rebecca

In my QV I have dynamic decimal point like I can have option to select how many decimal point I need like

.0, .00, .000, .0000 etc.

In your example it's fixed value .0000

Anyway to keep open decimal option?

Thanks