topic Re: How to show second in chart in QlikView

How to show second in chart

ashis — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to show second in chart

prieper — Tue, 19 Sep 2017 07:09:22 GMT

=Interval(End_Time - Start_Time,'ss') & ' seconds'

Re: How to show second in chart

Anil_Babu_Samineni — Tue, 19 Sep 2017 07:09:44 GMT

Is this works?

=Interval(End_Time - Start_Time,'ss') & 'sec'

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 07:12:29 GMT

Thank you for your reply, in expression append does not work.

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 07:12:43 GMT

Thank you for your reply, in expression append does not work.

Re: How to show second in chart

Anil_Babu_Samineni — Tue, 19 Sep 2017 07:18:16 GMT

Why Not?

Re: How to show second in chart

antoniotiman — Tue, 19 Sep 2017 07:20:51 GMT

Hi Ashis,

try like this

Replace(Interval(End_Time-Start_Time,'ss #ec'),'#','s')

=Replace(Interval('14:34:20','ss #ec'),'#','s')

Regards,

Antonio

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 07:22:13 GMT

I am using bar chart , and when I put this syntax, I do not get any result.

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 07:25:20 GMT

It is not working in bar chart.

Re: How to show second in chart

tresB — Tue, 19 Sep 2017 07:26:51 GMT

For bar chart, try like:

=Dual( Interval(End_Time - Start_Time,'ss') & 'sec' , Interval(End_Time - Start_Time,'ss') )

Re: How to show second in chart

Anil_Babu_Samineni — Tue, 19 Sep 2017 07:27:48 GMT

Try this?

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

Re: How to show second in chart

dinuwanbr — Tue, 19 Sep 2017 07:28:21 GMT

Hi Ashis,

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

Rgds,

Tharindu

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:04:23 GMT

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.

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:04:48 GMT

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.

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:09:55 GMT

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.

Re: How to show second in chart

Anil_Babu_Samineni — Tue, 19 Sep 2017 08:10:00 GMT

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

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:13:57 GMT

see the attached screen shot.

Re: How to show second in chart

Anil_Babu_Samineni — Tue, 19 Sep 2017 08:16:33 GMT

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'))

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:17:02 GMT

This should be 493 sec / 192 sec

Re: How to show second in chart

ashis — Tue, 19 Sep 2017 08:23:34 GMT

same result.