Discussion Board for collaboration related to QlikView App Development.
Trying to Export below Number of minutes Filed from straight table to Spread Sheet but this converts into hh:mm:ss as shown below:
How can I avoid this and output result should be in mins.
Thanks in advance.
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?
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:
I'd try your expression inside num, like:
Interval(Avg(Date(LeftDeptDateTime, 'DD/MM/YYYY hh:mm:ss') - Date(ArrDateTime,'DD/MM/YYYY hh:mm:ss')), 'm')
I have already tried this. No Luck
When we export the data in excel then same problem is coming.it's bug.
Kindly Export the data in csv file.