My actual issue is ...in a pivot table..we have a numeric value whihc reprsents secs. This secs value can be a large number which can be seconds counts of more than 10 days also.
I have to convert this to a hh:mm:ss field. the column level dimension contains Months. And the row level dim is just the measure name.
So for a Value like 19686141, i would need 5468:22:21. (hh:mm:ss). If i use the Time# function in qlikview, i get the hours only till 24 hrs. so I am using diff formuals to get individual items.
for hrs: FLOOR(SUM(AVAILTIME)/3600)
for min: floor(MOD(SUM(AVAILTIME),3600)/60)
for sec: MOD(SUM(AVAILTIME),60)
All these are retrieving fine in seperate expressions. but when I need them in a single expression, I need to concatenate them in a single expression and then display.
I have attached the qlikview file for your reference. The field AVAILTIME needs to be hh:mm;ss format. I was able to et AVAILTIME_hh, AVAILTIME_mm, AVAILTIME_ss using above calc. now i have to display them in hh:mm:ss format. Also a snapshot of the desired output in excel is attached.