topic Re: Quick question in QlikView

Quick question

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

I am trying to use this code in a text box:

=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))

and its showing me this number: 906086.66789

When I want it to show as: $906,086.66

When I do this:

=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)

Its show me the number as $3,000,000.86 (perfectly)

Thanks,

Re: Quick question

swuehl — Wed, 18 Oct 2017 19:09:24 GMT

Try

= Money(

Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))

)

and set the money format in the script (at the very beginning, the format codes are defined).

Re: Quick question

MK9885 — Wed, 18 Oct 2017 20:16:04 GMT

Maybe this?

num(Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))) ,'$#,##0;($#,##0.00)')

Re: Quick question

its_anandrjs — Thu, 19 Oct 2017 06:49:44 GMT

Try this in any text object

=NUM( Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin)),'$#,##0.00', '.',',')