topic Re: Number Format in QlikView

Number Format

upaliwije — Thu, 20 Apr 2017 07:54:19 GMT

In my text box I have following experession

=(NUM(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

NUM(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3,'#,##0.'))

But my output is not formatted and output is like given below.

69143848.666667

Pls advise me to get a output like 69,143,848

Anonymous — Thu, 20 Apr 2017 08:03:49 GMT

you must format not like num(A)-num(B) ,

but rather like

num(A-B)

kaushiknsolanki — Thu, 20 Apr 2017 08:04:21 GMT

Try this.

=(NUM(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3),'#,##0')

Regards,

Kaushik Solanki

upaliwije — Thu, 20 Apr 2017 08:53:09 GMT

The issue is still thre with following message

Error in expression

=(NUM(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3),'#,##0')

The comma 3), is highlighted in red

upaliwije — Thu, 20 Apr 2017 08:58:53 GMT

Anonymous — Thu, 20 Apr 2017 09:12:05 GMT

=NUM((sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3),'#,##0')

kaushiknsolanki — Thu, 20 Apr 2017 09:18:07 GMT

Try this,

NUM(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}

(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

(sum(

{<MO_NM={'MOTOR'}>}

(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))/3),'#,##0')

Regards,

Kaushik Solanki