topic Re: Help in roundoff! in QlikView

Help in roundoff!

Thu, 01 Dec 2011 05:49:35 GMT

If the percentage is 69.13% ir 69.65% I want to show it as 69%. Please helpme out to roundoff.

Thanks,
Attitude

Re: Help in roundoff!

Thu, 01 Dec 2011 06:11:15 GMT

Hi,

This you can do it using chart properties in that u have an option of fixed to, their u can set the number of decimal points u want.

Thanks & Regards,

Rathish

Help in roundoff!

Thu, 01 Dec 2011 06:18:32 GMT

Hi Rathish

I have already tried that but it is not working as expected. Problem is sales value of a particular month is different when you change the selection.

Please let me know if you have anyother suggestion please.

Thanks,

Attitude

Help in roundoff!

Thu, 01 Dec 2011 07:14:08 GMT

Hi At titude

You can use #,##0% format in your chartexpression.

Thanks & Regards,

Rathish

Re: Help in roundoff!

Thu, 01 Dec 2011 07:25:16 GMT

Hi Rathish

You mean to say something like below? I tried it but it is throwing error(Bad field names). Please do reply!

Num('EXPRESSION',#,##0%)

Thanks,

Attitude

Re: Help in roundoff!

Thu, 01 Dec 2011 07:42:31 GMT

Hi At titude,

Num('EXPRESSION',#,##0%,field)

in the expression u can use this format.so that u can it wil remove the decimal points

Help in roundoff!

Anonymous — Thu, 01 Dec 2011 07:52:36 GMT

What if you try:

Floor(Num('EXPRESSION'))

And set the number format to o decimals in the number format settings on the number tab

Re: Help in roundoff!

Thu, 01 Dec 2011 08:39:43 GMT

Hi At titude,

I mean to say like this

if(COMMONSUBGROUP='GM %' or COMMONSUBGROUP='EBIT%',Num(Sum(Actual),'#,##0%'),Sum(Actual))

Thanks & Regards,

Rathish

Re: Help in roundoff!

Thu, 01 Dec 2011 08:57:25 GMT

Hi Rathish

What should be passed in place of field? I my case I am using cyclic group. When I passed in the below formula it didn't work. Please let me know if you have any other solution.

Num('EXPRESSION',#,##0%,field)

The exact problem is, for example when I select Week as 45 value it is showing % of profit is as 69% and where are when I select Week 45 for the same week it is showing profit as 70%. The report is very complicated. We are trying to do the week on week sale and month on month sale. Hope my problem is understood.

Thanks,

Attitude

Re: Help in roundoff!

Thu, 01 Dec 2011 09:00:20 GMT

Hi Dennis

I have tried it is not working as expected. Please let me know if you have any other suggestion. It is little urgent.

Thanks,

Attitude

Re: Help in roundoff!

Anonymous — Thu, 01 Dec 2011 09:06:20 GMT

What is the expression you are using?

Re: Help in roundoff!

Thu, 01 Dec 2011 09:14:58 GMT

Hi Rathish

In the same report when I select different weeks. For the first selection it is showing percentage as 70% when it's exact percentage is 69.50% and for the second selection it is showing it as 69% when the exact percentage is 69.29%. For both the selection selection of week is same but it showing different value because of the number format.

Hope my requirement are understandable. If not please let me know.

Thanks,

Attitude

Re: Help in roundoff!

Thu, 01 Dec 2011 09:21:28 GMT

Hi Dennis

In each expression we are calculating the sales for last 14 weeks(week on week). So each expression contains the sales of the week. So when I select week 43 it is show last 14 week sale and when I select week 40 it will show last 15 week sale. So everything is dynamic.

So when I select the week 43 and week 40. Sale for week 35 is 69% when week 43 is selected and sale for week 35 is 70 when week 40 is selected.

Thanks,

Attitude

Re: Help in roundoff!

Anonymous — Thu, 01 Dec 2011 09:32:58 GMT

So what happens, what is the outcome, when you use:

Floor(Num("FIRSTSELECTION" / "SECONDSELECTION"))

Re: Help in roundoff!

Thu, 24 Oct 2013 22:17:11 GMT

round function?