topic Re: Percentage in table in QlikView

Percentage in table

Tue, 03 May 2016 09:11:24 GMT

Hello All,

I am trying to show the percentage in my expression but it doesnt seem to work.

I must use the expression to show the percentage as I do have lines in my tables which does not need to show percentage sign.

Example of my table:

Below is my expression for Question A :

num(Count({<Q11={'OUI','Oui'}>}Q11) / (Count({<Q11={'OUI','Oui'}>}Q11) + Count({<Q11={'NON','Non'}>}Q11))*100,'#.##0,00%')

In the number tab, I assigned it to Fix, 1 decimal place.

Any idea?

Many thanks,

Hasvine

sunny_talwar — Tue, 03 May 2016 09:13:29 GMT

Did you also put a check nexty to Show in Percent (%)?

I take that back, You are formatting based on the expression, you need to select Expression Default here

UPDATE: Also remove *100 from the expression

Num(Count({<Q11={'OUI','Oui'}>}Q11) / RangeSum(Count({<Q11={'OUI','Oui'}>}Q11), Count({<Q11={'NON','Non'}>}Q11)),'#.##0,0%')

Kushal_Chawda — Tue, 03 May 2016 09:16:27 GMT

try this

num(Count({<Q11={'OUI','Oui'}>}Q11) / rangesum(Count({<Q11={'OUI','Oui'}>}Q11) ,Count({<Q11={'NON','Non'}>}Q11),'#0.00%')

arasantorule — Tue, 03 May 2016 09:16:29 GMT

Hi,

Can you try as below in the number tab in table properties.

Thanks

Tue, 03 May 2016 11:32:09 GMT

Thanks for your help Sunny.

Kind Regards,

Hasvine