Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator III

How to show second in chart

Hello ,

I have two time column and I am calculating second using the following syntax, in the bar chart.

=Interval(End_Time - Start_Time,'ss')

I am getting the proper time in second in the chart in numeric format, now I want to print second text in the chart such as

30 sec , instead of 30 .

in the number tab if I change format setting from expression default to interval and put ss second , I did not get the result.

Could you please help me how to get it.

Thank you,

Ashis

34 Replies
Anil_Babu_Samineni

Try this?

Dual(Interval(Works,'ss') & ' sec', Interval(Works,'ss'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
dinuwanbr
Creator III
Creator III

Hi Ashis,

Check this. If your problem is still please upload a sample.

Rgds,

Tharindu

ashis
Creator III
Creator III
Author

Hi Tresesco,

As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.

=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))

is anything I am missing.

ashis
Creator III
Creator III
Author

As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.

=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))

Is anything I am missing.

ashis
Creator III
Creator III
Author

Hi,

You are taking as calculated dimension, where as I am calculating it in the expression . I am using different dimensions in my chart. I need to calculate it in expression only and in the chart need to show as 20 sec or 30 sec instead of 20 or 30.

Thank you for your reply.

Anil_Babu_Samineni

What you are showing that is correct synthetically. Share me the image using 2 formulas in straight table

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ashis
Creator III
Creator III
Author

see the attached screen shot.

Anil_Babu_Samineni

Can you try this? Or i would need application to test

=dual(Interval(End_Time - Start_Time,'hh:mm:ss')*60*60 & ' Sec',Interval(End_Time - Start_Time,'ss'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ashis
Creator III
Creator III
Author

This should be  493 sec / 192 sec

ashis
Creator III
Creator III
Author

same result.