Discussion board where members can get started with Qlik Sense.
I am experiencing a strange issue.
I have calculated a measure that's like:
SUM(INTERVAL(EndingDate - StartingDate, 'h')) that should measure the sum, in hours, of the duration of some kind of processes.
No problems this far.
I then created some visualizations, for example a KPI: it shows me 9400.
Nice, but I'd like to show the separator of the thousands. So I edit the KPI, find the measure and change the formatting, changing if from "Automatic" to "Number".
Nice, now it should show me 9.400...nope. It shows me 391,67 that is 9400/24, it's changing it from hours to days.
Why does it so?And how can I format the measure?I've read https://help.qlik.com/it-IT/sense/September2017/Subsystems/Hub/Content/Scripting/FormattingFunctions... but it's not very intuitive.
Should I measure it in days, formatting it as number and multiply the measure by 24?
Go to Solution.
Maybe something like
num ( sum ( EndingDate - StartingDate ) * 24 , '#,##0' )
I tried changing to SUM(INTERVAL(EndingDate - StartingDate, 'd')) and it shows the same results.
I guess I'll have to use your formula...
If you want to use the Interval() function, then as that will be doing the formatting try putting the Interval() as outer part of your expression :
Interval ( Sum ( EndingDate - StartingDate ) , 'd' )
It seems to cause no differences...