topic Re: Number format in QlikView

Number format

evansabres — Fri, 23 Jun 2017 16:30:34 GMT

I have an expression

=(NUM(SUM(IF(pkgNME='Bronze', [Net Sold Qty])),'#,###.')/vBronzePKG)

That every time I enter the equation, gives me a result of 714.0916184.

I have the number format at the end of this expression to avoid the decimals.

Am i entering the format of this equation correctly.

sunny_talwar — Fri, 23 Jun 2017 16:32:08 GMT

Try this

=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG),'#,###.')

sunny_talwar — Fri, 23 Jun 2017 16:32:46 GMT

Better yet, try this

=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG),'#,###.')

evansabres — Fri, 23 Jun 2017 16:36:21 GMT

Both of these give a result of 'Garbage after the expression: ","

sunny_talwar — Fri, 23 Jun 2017 16:37:49 GMT

My bad, try this

=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG, '#,###.')

sunny_talwar — Fri, 23 Jun 2017 16:39:04 GMT

or this

=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG,'#,###.')

evansabres — Fri, 23 Jun 2017 16:39:22 GMT

Thank you for your help.