topic Re: Concatenate 2 number expressions in QlikView

Concatenate 2 number expressions

Wed, 03 Dec 2014 10:21:41 GMT

Hello

I am very new to Qlikview so would really appreciate some help please..

I am displaying %s in a pivot table chart - the expression is called 'Compliant %' and the calculation is

round

(sum(CompCount)/
sum([Person Headcount]),0.01)

I would like to also show the number of staff who are non-compliant in brackets next to this percentage e.g. 50% (2), so have tried concatenating the 2 fields but this does not work

The calculation for the field Non compliant is

sum

(NonCount)

Thanks

Re: Concatenate 2 number expressions

adiarnon — Wed, 03 Dec 2014 10:26:44 GMT

try-

=round(sun(CompCount)/sum([Person HeadCount]),0.01)&' ('&sum(NonCount)&')'

Re: Concatenate 2 number expressions

its_anandrjs — Wed, 03 Dec 2014 10:28:45 GMT

Try this way also

round(sum(CompCount)/ sum([Person Headcount]),0.01) &'(' & sum (NonCount) & ')'

Regards

Anand

Re: Concatenate 2 number expressions

Wed, 03 Dec 2014 10:33:52 GMT

Great, thank you - that works! But I didn't think of the fact that it comes out as a number and not percentage!

So comes out as 0.99 (13), when I really want it to show 99% (13) - can you advise?

Re: Concatenate 2 number expressions

its_anandrjs — Wed, 03 Dec 2014 10:48:14 GMT

Try this expression

=round(sun(CompCount)/sum([Person HeadCount]),0.01)*100&'%' &' ('&sum(NonCount)&')'

Regards

Anand

Re: Concatenate 2 number expressions

Wed, 03 Dec 2014 10:49:19 GMT

don't worry - have figured it out

=(round(sum(CompCount)/
sum([Person Headcount]),0.01))*100 &'%' &' ('&sum(NonCount)&')'

Thanks for the replies

Re: Concatenate 2 number expressions

adiarnon — Wed, 03 Dec 2014 10:50:02 GMT

you can try-

=round(sum(ComCount)/sum([Person headcount]),0.01)*100&'% ('&sum(NinCount)&')'

Re: Concatenate 2 number expressions

Wed, 03 Dec 2014 10:53:08 GMT

Thanks Anand – I had just twigged as you responded!

Thanks for your help

Re: Concatenate 2 number expressions

Shubham_D — Fri, 08 May 2020 15:05:13 GMT

Hi @adiarnon ,

How to change color conditionally for such expression ?

Qliksense iis not allowing to change to color conditionally /

Rgds,'Shubham