Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Percentage in table

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:

QuestionAnswer
Q1410,0
Q1190,2%
Q135.0
Q127.0%

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

1 Solution

Accepted Solutions

Re: Percentage in table

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%')

Capture.PNG

4 Replies

Re: Percentage in table

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%')

Capture.PNG

Re: Percentage in table

try this

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

arasantorule
Contributor III

Re: Percentage in table

Hi,

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

Percentage.png

Thanks

Not applicable

Re: Percentage in table

Thanks for your help Sunny.

Kind Regards,

Hasvine

Community Browser