Concatenate 2 number expressions

[#1]

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

[adiarnon · Accepted solution]

try-

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

[its_anandrjs]

Try this way also

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

Regards

Anand

[#4]

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?

[its_anandrjs]

Try this expression

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

Regards

Anand

[#6]

don't worry - have figured it out

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

Thanks for the replies

[adiarnon]

you can try-

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

[#8]

Thanks Anand – I had just twigged as you responded!

Thanks for your help

[Shubham_D]

Hi @adiarnon ,

How to change color conditionally for such expression ? 

Qliksense iis not allowing to change to color conditionally /

Rgds,'Shubham