Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chrisgoudy
New Contributor II

Change Expression for TextBox Object

How do I change the following Expression of my TextBox Object so that the percentage has no decimals?

=Sum(Flag) &' (' & (sum(Flag)/sum({1}Flag))*100 &')' &'%'

1 Solution

Accepted Solutions

Change Expression for TextBox Object

Hi,

Check with this,

     =Sum(Flag) &' (' & Num((sum(Flag)/sum({1}Flag))*100,0) &')' &'%'

Hope it helps

Celambarasan

2 Replies

Change Expression for TextBox Object

Hi,

Check with this,

     =Sum(Flag) &' (' & Num((sum(Flag)/sum({1}Flag))*100,0) &')' &'%'

Hope it helps

Celambarasan

chrisgoudy
New Contributor II

Change Expression for TextBox Object

Thank you, just what I needed.