reduce digits after point in num function

[#1]

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? !

[alexandros17]

Please close the previous question and open a new one.

Thanks

[#3]

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

[jagan]

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.

[qlikviewwizard]

Hi veerendra999,

Please select Correct Answer and close the thread.Thank you.