13 Replies Latest reply: Jul 6, 2015 9:15 PM by arjun rao

# reduce digits after point in num function

Hi

i have question in recent scenario  i have straight table and values below like this and i wanted show values and sorting become specific order.

output needs to be below like this.key points field are sorted to specific order and reduced to only two digits. above mentioned is the example and below is the output.how do i do? !

• ###### Re: reduce digits after point in num function

in "number" tab  select "fixed to" and set 2 digits.then in sort select REGION (press on promote to set it as first item)

• ###### Re: reduce digits after point in num function

Hi,

You can format number by go to chart property->Number->Fixed to->2

and if you want with specific order

go to sort->select field->in sort write expression->match(Region,'Americas','Asia*','Europe','Africa')

Regards

• ###### Re: reduce digits after point in num function

max dreamer wrote:

go to sort->select field->in sort write expression->match(Region,'Americas','Asia*','Europe','Africa')

That should be

=wildmatch(Region,'Americas','Asia*','Europe','Africa')

• ###### Re: reduce digits after point in num function

You can limit number as 2 decimal points in Properties->Number->Fixed with 2 decimal.

For sorting, what is the logic for the specific sort order?

• ###### Re: reduce digits after point in num function

Hi,

If you share the sample file or data then it would be easier to give solution, without this it is difficult to answer.

Go through below link for some useful tips to get the answers quickly

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.

• ###### Re: reduce digits after point in num function

for sorting in the sense  i have dimension Region below like:

Africa

Americas

Asia and Pasific

Europe

Need to output like below

Americas

Asia and Pasific

Europe

Africa

• ###### Re: reduce digits after point in num function

Hi,

Try like this

Chart Properties -> Sort-> Select Region Dimension -> Select Expression and give below expression

=Match(Region, 'Americas', 'Asia and Pasific', 'Europe', 'Africa')

Hope this helps you.

Regards,

Jagan.

• ###### Re: reduce digits after point in num function

Hi qv beginner,

Can you attach the sample file?

• ###### Re: reduce digits after point in num function

Here it is

• ###### Re: reduce digits after point in num function

Thanks Guys for sharing your valuable experience

kindly challenge below gauge chart because i have 3 years of date each your should be show indicator like below per each year how to solve share me screen shots

my dimension:

year: 10-11

11-12

12-13

expression Sum(Revenue)

share me screens..

• ###### Re: reduce digits after point in num function

I suggest that you create a new post because this is a new question only loosely related to the original question.

• ###### Re: reduce digits after point in num function

Please close the previous question and open a new one.

Thanks

• ###### Re: reduce digits after point in num function

Hi qv beginner,