Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner
Partner

Different format while Exporting to excel and copy data to Clipboard

Hello!

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

Image3.jpg

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"

Image2.jpg

Data is displayed in h:mm:ss format

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

Image1.jpg

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

1 Solution

Accepted Solutions
vlad_komarov
Partner
Partner
Author

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.

View solution in original post

2 Replies
vlad_komarov
Partner
Partner
Author

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.

View solution in original post

vlad_komarov
Partner
Partner
Author

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.