Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
narband2778
Creator II
Creator II

Trying to Export to Excel but Minutes are converting to hh:mm:ss

Hello Everyone,

Trying to Export below Number of minutes Filed from straight table to Spread Sheet but this converts into hh:mm:ss as shown below:

Before :

1.png

After:

2.png

How can I avoid this and output result should be in mins.

Thanks in advance.

Naresh

5 Replies
Anil_Babu_Samineni

I never come this type of issue while exporting? Can you show image exactly how Straight table looks like? Have you applied any Format condition to achieve in minutes?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
narband2778
Creator II
Creator II
Author

Hi Anil,

This is expression for "Avg LOS in mins"

=Interval(Avg(Date(LeftDeptDateTime, 'DD/MM/YYYY  hh:mm:ss') - Date(ArrDateTime,'DD/MM/YYYY  hh:mm:ss')), 'm')

Below is the Straight Table:

1.png

Thanks,

Naresh

lcontezini
Partner
Partner

I'd try your expression inside num, like:

num(

Interval(Avg(Date(LeftDeptDateTime, 'DD/MM/YYYY  hh:mm:ss') - Date(ArrDateTime,'DD/MM/YYYY  hh:mm:ss')), 'm')

,'#.##0')

narband2778
Creator II
Creator II
Author

Hi,

I have already tried this. No Luck

panipat1990
Creator II
Creator II

When we export the data in excel then same problem is coming.it's bug.

Kindly Export the data in csv file.