topic Re: reversing a number in QlikView

reversing a number

Wed, 25 Nov 2020 16:16:04 GMT

hi,

i'm struggling to reverse the output here without ant success. would appreciate if someone helps

=num(sum({$<Dist_Date={"$(=Date(AddMonths(Max(Dist_Date), -1), 'MMM-YYYY'))"}>}[Gross Sales])/1000000,'#,###M')

sunny_talwar — Thu, 11 May 2017 18:03:08 GMT

What do you mean when you say reverse the output?

Thu, 11 May 2017 18:05:49 GMT

Hi,

I just needed the output of the above expression on the negative axis despite a positive number. I completed it by multiplying the expression by -1.

Thanks anyway

swuehl — Thu, 11 May 2017 18:22:06 GMT

Maybe just multiply by a Million and format as you like, without the postfix?

=Num( Num( 123456 / 1000000 ,'#,###M')*1000000,'#,##0')

edit: this expression using two num() obviously doesn't make sense, it should just show the principle