topic Re: Remove % Symbol in QlikView

Remove % Symbol

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to remove the '%' symbol in the below chart.

Thanks..

Re: Remove % Symbol

sunny_talwar — Tue, 04 Oct 2016 13:17:49 GMT

Are you using formatting in the expression (using Num) or are you using Number tab's formatting?

Re: Remove % Symbol

devarasu07 — Tue, 04 Oct 2016 13:24:57 GMT

Hi,

to remove % symbol from bar values

Go to Chart properties --> number tab --> uncheck for show in percent (%)

Thanks

Dev

Re: Remove % Symbol

johanlindell — Tue, 04 Oct 2016 13:29:23 GMT

Add a second expression with different formatting and no bars.

Re: Remove % Symbol

giakoum — Tue, 04 Oct 2016 13:44:25 GMT

Re: Remove % Symbol

el_aprendiz111 — Tue, 04 Oct 2016 13:49:02 GMT

Re: Remove % Symbol

giakoum — Tue, 04 Oct 2016 13:56:28 GMT

cool

Re: Remove % Symbol

nareshthavidishetty — Tue, 04 Oct 2016 14:09:48 GMT

Hi Sunny,

i'm used the num in the expression.

Logic: num(aggr(sum({<Date={$(varMaxDate)},flag={'e_Inititated'}>} Contracts),Location,District)/aggr(sum({<Date={$(varMaxDate)},flag={'Daily_Total'}>} Contracts),Location,District),'#,##0%')

Thanks..

Re: Remove % Symbol

sunny_talwar — Tue, 04 Oct 2016 14:13:24 GMT

How about this?

Num(Aggr(Sum({<Date={$(varMaxDate)},flag={'e_Inititated'}>} Contracts),Location,District)/Aggr(Sum({<Date={$(varMaxDate)},flag={'Daily_Total'}>} Contracts),Location,District) * 100,'#,##0')

Re: Remove % Symbol

antoniotiman — Tue, 04 Oct 2016 14:14:02 GMT

Num(YourExpression*100,'#.##0') (or , instead of . according to Your separator)

and in Tab Number check 'Default Expression'

Re: Remove % Symbol

nareshthavidishetty — Tue, 04 Oct 2016 14:24:47 GMT

Hi Sunny,

I'm getting the below result..

Thanks..

Re: Remove % Symbol

nareshthavidishetty — Tue, 04 Oct 2016 14:27:28 GMT

Hi Sunny,

It's working fine.Actually i have set the min and max to the axis after remove it's fine.

Thanks..

Re: Remove % Symbol

sunny_talwar — Tue, 04 Oct 2016 14:27:40 GMT

Do you have a static min, max and steps on the axis tab? You might want to remove those.

Re: Remove % Symbol

sunny_talwar — Tue, 04 Oct 2016 14:28:00 GMT

Hahahaha ya, that's what I just mentioned above