topic Re: Export to excel number format not working in QlikView

Export to excel number format not working

Thu, 30 Mar 2017 19:18:00 GMT

Hi,

This calculated dimension =aggr(sum(aggr(count(TranscriptCompletions),[Employee Id],[Course Number])), [Employee Id]) returns a value.

When I export this to excel, the exported value is in text format. I tried using NUM#() and NUM(), but it is still giving me issues.

Please suggest!

CarlosAMonroy — Thu, 30 Mar 2017 19:56:22 GMT

Hi Naveed,

Go to Settings -> Document Properties and under the 'Number' tab search for TranscriptCompletions field and set it to be number.

Hope that helps,

Carlos M

el_aprendiz111 — Thu, 30 Mar 2017 20:15:52 GMT

Hi,

=aggr(sum(aggr(count(TranscriptCompletions),[Employee Id],[Course Number])), [Employee Id]) *1

Thu, 30 Mar 2017 21:12:33 GMT

Tried it. Does not work.

Thu, 30 Mar 2017 21:19:58 GMT

Does not work. Nice try though!