topic Different format while Exporting to excel and copy data to Clipboard in QlikView

Different format while Exporting to excel and copy data to Clipboard

vlad_komarov — Mon, 29 Aug 2011 21:56:36 GMT

Hello!

I have multiple charts in my application that displays some time trends:

I am using an Interval Number option in these charts with "h:mm" format pattern

But I have different results during different export methods:

Results after "Send Values to Excel"

Data is displayed in h:mm:ss format

Results after "Copy to Clipboard"--> "Values"-->"Paste to Excel"

Data is displayed as expected, in "h:mm" format.

Any suggestions how to make the "Send Values to Excel" option to follow the required format?

Thanks!

Best regards,

Vladimir

Different format while Exporting to excel and copy data to Clipboard

vlad_komarov — Tue, 30 Aug 2011 06:59:48 GMT

The solutiuon is actually to use the time(Number, 'h:mm') method in all expressions and set the Number Option to "Expression Default". It sometimes creates a problem for displaying time values on chart's Y axis, but it seems to be working on all other cases.

Overall, it looks like a bug in QV.

Different format while Exporting to excel and copy data to Clipboard

vlad_komarov — Tue, 30 Aug 2011 07:16:42 GMT

But you need to be careful with Time() function if you are doing totals on the charts.

Using h:mm format leaves only hours and minutes and truncates Days from the total if sum of your time periods is big enough.