topic Re: Number in QlikView

Number

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl,

IN my table iam getting the output as shown in the Screenshot..

My requirement is like it should not show any decimal when it is zero ..

other than that it should show decimal for other number ..

how do i format this ?

Thanks

Re: Number

devarasu07 — Mon, 16 Oct 2017 05:15:49 GMT

Hi,

Method1:

by default it should give expected result. Try to set expression default option or Number radio button under Number tab - chart object

Method2:

Try like this

if(Mod(Sales,1)=0,num(Sum (Sales),'#,##0'),num(Sum (Sales),'#,##0.0'))

Re: Number

smilingjohn — Mon, 16 Oct 2017 05:26:00 GMT

Hi , Expertise

I got that thing resolved by giving

### in the number format ..

As shown in the screenshot i want to bring this negative values in the top..under sorting .

please need your help to achive this ...

Iam using this expression to achive this ..do i need to make changes in this expression to achive the begative values in the forst row or shuld i do it in the sorting ?

sum(Expensed)-sum(Claimed)

Thanks in advance

Re: Number

devarasu07 — Mon, 16 Oct 2017 05:30:44 GMT

Hi,

Just try to enable ascending sort order for that calculated measure column (i.e in your chart object--> sort tab )

Re: Number

smilingjohn — Mon, 16 Oct 2017 05:33:53 GMT

HI Devarasu,

This is not getting enables ?

Its graded out ..

What should i do sir ?

Thanks

Re: Number

devarasu07 — Mon, 16 Oct 2017 05:54:10 GMT

Hi,

Would be able to share your app /mock document? tks