Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

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
Contributor II

Re: Value changes after export to Excel

After lots of research, solved by changing the measure:

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

Number Format: Auto

4 Replies
Chanty4u
Esteemed Contributor III

Re: Value changes after export to Excel

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

Shahzad_Ahsan
Contributor II

Re: Value changes after export to Excel

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
Contributor II

Re: Value changes after export to Excel

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

Shahzad_Ahsan
Contributor II

Re: Value changes after export to Excel

After lots of research, solved by changing the measure:

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

Number Format: Auto

Community Browser