Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try-
=round(sun(CompCount)/sum([Person HeadCount]),0.01)&' ('&sum(NonCount)&')'
try-
=round(sun(CompCount)/sum([Person HeadCount]),0.01)&' ('&sum(NonCount)&')'
Try this way also
round(sum(CompCount)/ sum([Person Headcount]),0.01) &'(' & sum (NonCount) & ')'
Regards
Anand
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?
Try this expression
=round(sun(CompCount)/sum([Person HeadCount]),0.01)*100&'%' &' ('&sum(NonCount)&')'
Regards
Anand
don't worry - have figured it out
=(round(sum(CompCount)/
sum([Person Headcount]),0.01))*100 &'%' &' ('&sum(NonCount)&')'
Thanks for the replies
you can try-
=round(sum(ComCount)/sum([Person headcount]),0.01)*100&'% ('&sum(NinCount)&')'
Thanks Anand – I had just twigged as you responded!
Thanks for your help
Hi @adiarnon ,
How to change color conditionally for such expression ?
Qliksense iis not allowing to change to color conditionally /
Rgds,'Shubham