topic Re: text box script - show a % in QlikView

text box script - show a %

Thu, 19 Dec 2013 12:07:13 GMT

Hi,

Came across really cool expression that shows a headline figure in the form of a text box:

='£' & Num(Round(sum([Tenant_Arrears])), '#,##0')

however, when trying to show another figure, this time a % were struggling. The script is below to try and get this % figure and works in princple in a straight table but we want this text box to just to show 'decent' properties as a % of all properties.

Current script : Num(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]), '#.##%')

Decency is the field with the 3 options of 'Decent', 'Non-decent' and Potentially Non-decent'

Figures used: 'Decent' = 4376, 'Non-decent' = 199 and Potentially Non-decent' = 10009

Appreciate any help.

Cheers

Chris

Re: text box script - show a %

Thu, 19 Dec 2013 12:15:36 GMT

try this

Num(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]), '#.##0') & '%'

Re: text box script - show a %

tresB — Thu, 19 Dec 2013 12:20:16 GMT

Total keyword is used to ignore dimensions in charts. So in text box it has no relavance, you may try {1} like:

Num(Count ([Decency]= 'Decent')/ Count({1}[Decency]), '#.##%')

Re: text box script - show a %

Anonymous — Thu, 19 Dec 2013 12:21:33 GMT

Try this

(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]))*100 & '%',

Re: text box script - show a %

Thu, 19 Dec 2013 12:26:09 GMT

Use set analysis:

=Num(Count ({<[Decency]= {Decent}>} [Decency])/ Count({1} [Decency]), '#,##0.00%')