Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Shahzad_Ahsan
Creator III
Creator III

Value changes after export to Excel

Hi Experts

I am facing problem with hours. Please check the highlighted column of snapshot.

The value changes after exporting. I am using interval function that is why i am facing problem.

My measure is  :     interval(sum(early_hours),'hh')

Please suggest some changes in measure expression only. I don't want to make any changes in excel.

QS.jpg

Ex.jpg

1 Solution

Accepted Solutions
Shahzad_Ahsan
Creator III
Creator III
Author

After lots of research, solved by changing the measure:

Floor( interval(sum(early_hours),'hh')*24)

Number Format: Auto

View solution in original post

4 Replies
Chanty4u
MVP
MVP

try to set custom number format in setting in qliksense i think

Shahzad_Ahsan
Creator III
Creator III
Author

Hi chanty

When I go to excel and set custom format to "" then it works fine. But I am not able to use this custom format in qliksense. It is giving error.

Shahzad_Ahsan
Creator III
Creator III
Author

I have made number formatting as 'Duration' and Format Pattern as 'hh' . then also not working.

Shahzad_Ahsan
Creator III
Creator III
Author

After lots of research, solved by changing the measure:

Floor( interval(sum(early_hours),'hh')*24)

Number Format: Auto