topic reduce digits after point in num function in QlikView

reduce digits after point in num function

Mon, 06 Jul 2015 07:48:29 GMT

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

alexandros17 — Mon, 06 Jul 2015 07:53:22 GMT

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

PrashantSangle — Mon, 06 Jul 2015 07:54:40 GMT

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

Mon, 06 Jul 2015 07:56:30 GMT

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

jagan — Mon, 06 Jul 2015 08:01:44 GMT

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

jonathandienst — Mon, 06 Jul 2015 08:05:23 GMT

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

qlikviewwizard — Mon, 06 Jul 2015 08:16:56 GMT

Hi veerendra999,

Can you attach the sample file?

Re: reduce digits after point in num function

alexandros17 — Mon, 06 Jul 2015 08:24:18 GMT

Here it is

Re: reduce digits after point in num function

Mon, 06 Jul 2015 09:29:30 GMT

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

jonathandienst — Mon, 06 Jul 2015 09:35:15 GMT

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

alexandros17 — Mon, 06 Jul 2015 09:39:07 GMT

Please close the previous question and open a new one.

Thanks

Re: reduce digits after point in num function

Mon, 06 Jul 2015 09:40:30 GMT

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

jagan — Mon, 06 Jul 2015 09:48:34 GMT

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

qlikviewwizard — Tue, 07 Jul 2015 01:15:55 GMT

Hi veerendra999,

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