Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
After lots of research, solved by changing the measure:
Number Format: Auto
try to set custom number format in setting in qliksense i think
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.
I have made number formatting as 'Duration' and Format Pattern as 'hh' . then also not working.