topic Re: numeric format of calculated dimension? in QlikView

numeric format of calculated dimension?

sushil353 — Fri, 09 Sep 2011 10:23:44 GMT

Hi All

I have a calculated a dimention as =aggr((Sum({<DT_TYPE=>}NDFNDR_SUMMARY.TOTAL_DEFECTS)/Sum ({<OP_VERNUM={1},DT_TYPE=>}total<OT_DESCRIPTION> TOTAL_UNITS_PROCESSED)*100)),NDFNDR_SUMMARY.MT_TYPE)

the results are comming as 1.3837418378

but i want the result format as 1.38 means upto 2 decimal point..

how this can be achieved...

Thanks

numeric format of calculated dimension?

IAMDV — Fri, 09 Sep 2011 10:28:50 GMT

Have you tried using the Num() function? The Num function formats the expression numerically according to the string given as format-code.

Cheers - DV

Re: numeric format of calculated dimension?

Sokkorn — Fri, 09 Sep 2011 11:43:29 GMT

Hi Sushil,

Let try this:

NUM(
aggr((Sum({<DT_TYPE=>}NDFNDR_SUMMARY.TOTAL_DEFECTS)/Sum ({<OP_VERNUM={1},DT_TYPE=>}total<OT_DESCRIPTION> TOTAL_UNITS_PROCESSED)*100)),NDFNDR_SUMMARY.MT_TYPE)
,'###,###.##')

Regards,

Sokkorn