Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
After lots of research, solved by changing the measure:
Floor( interval(sum(early_hours),'hh')*24)
Number Format: Auto
try to set custom number format in setting in qliksense i think
Hi chanty
When I go to excel and set custom format to "
I have made number formatting as 'Duration' and Format Pattern as 'hh' . then also not working.
After lots of research, solved by changing the measure:
Floor( interval(sum(early_hours),'hh')*24)
Number Format: Auto