topic Re: How can we use Strings in Bar Chart Expression in QlikView

How can we use Strings in Bar Chart Expression

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

Hi Folks,

I have one requirement. How can we show Strings in Bar Chart Expression. I am having data which shows Duration. I want to Include strings with numbers like 'Days','Hours','Minutes'

if you see the Image at Acer I am getting 13478:7:18 I want to see this ca13478 Days 7 Hours 18 Mins

Below is the expression I am using

=Floor(sum(Duration)/60/8) &':'& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ':' &

Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1))

For reference you can find attached data & attached qvw. Can any one please help me on this

Thanks and Regards,

Satya

Re: How can we use Strings in Bar Chart Expression

tresB — Tue, 31 Oct 2017 05:50:07 GMT

Use dual(). PFA

Re: How can we use Strings in Bar Chart Expression

SatyaPaleti — Tue, 31 Oct 2017 05:54:26 GMT

Hi Tresco,

Thank you for responce. I have tried writing dual but missing some where. Could you please reply with expression you are writing

Thanks and Regards,

Satya

Re: How can we use Strings in Bar Chart Expression

tresB — Tue, 31 Oct 2017 05:55:44 GMT

=Dual(

Floor(sum(Duration)/60/8) &' Days '& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ' Hours ' &

Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1)) & ' Mins ',

Floor(sum(Duration)/60/8) &':'& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ':' &

Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1))

)

Re: How can we use Strings in Bar Chart Expression

SatyaPaleti — Tue, 31 Oct 2017 06:10:19 GMT

Thank you so much Tresco

Re: How can we use Strings in Bar Chart Expression

tresB — Tue, 31 Oct 2017 06:13:50 GMT

You would probably want to close the thread by marking 'correct' answer?