topic Millions with single decimal value only in QlikView

Millions with single decimal value only

bushpalaamarnat — Fri, 01 Jun 2018 15:03:18 GMT

Hi All,

Following is the formula used in dimension to create the table chart.

=NUM(AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)

Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND),'###,###,###.')

the output i get is 456,456 for example.

Kindly advise, i need the out put as 0.4(M)

Could you advise how to amend the formula.

Re: Millions with single decimal value only

Frank_Hartmann — Fri, 01 Jun 2018 15:49:59 GMT

Maybe like this:

floor(AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)-Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND),100000,100000)/1000000&'(M)'

Re: Millions with single decimal value only

prat1507 — Fri, 01 Jun 2018 15:53:23 GMT

Probably this

=NUM((AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)

Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND))/1000000,'###.# (M)')