Value changes after export to Excel

[Shahzad_Ahsan]

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.

[Chanty4u]

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

[Shahzad_Ahsan]

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]

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

[Shahzad_Ahsan · Accepted solution]

After lots of research, solved by changing the measure:

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

Number Format: Auto