Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

reversing a number

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')

3 Replies
sunny_talwar

What do you mean when you say reverse the output?

Not applicable
Author

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
MVP
MVP

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