topic Re: % in expression in QlikView

% in expression

Sat, 08 Feb 2014 17:08:04 GMT

Is it possible to add "%" sign to a number in expression?

here is my diagram:

Now, I would like to add "%" sign to every value, for example in diagram you can see "7.1". I would like it to be "7.1%"

Thanks!

MK_QSL — Sat, 08 Feb 2014 17:10:41 GMT

In expressions, please untick value on data points.

Add same expression with &'%'

i.e. SUM(Sales) &' %'

Here untick bar and tick value on data points

swuehl — Sat, 08 Feb 2014 17:11:46 GMT

Maybe divide your expressions by 100 and set number format in number tab to percentage?

Sat, 08 Feb 2014 17:26:45 GMT

Thanks! It is exactly what I wanted to do!

I have another question (not related to editing the chart).
here is the situation: I have two tables

Table A attributes: Age, "Total Population", "Mobile User (Unique User)"

Table B attributes: Sex, "Total Population", "Mobile User (Unique User)"

When I reload the script, my first chart (based on Table A) goes crazy.
What should I do in order to analyse the two tables separately?

Thanks!

Sat, 08 Feb 2014 19:30:44 GMT

Num(Sum(Sales ),'##,#0%') This is Num()

Sat, 08 Feb 2014 21:00:04 GMT

I do not understand
Could you elaborate on this please?

Sat, 08 Feb 2014 21:01:05 GMT

Sorry, I was thinking you are referring to my second question - the problem described in first question is solved.

MK_QSL — Mon, 10 Feb 2014 19:46:47 GMT

May be because your both tables two fields are common and creating a synthetic key.

You should either try to rename the Population or Mobile User field or try

CAN HELP YOU better is I have your sample script.