Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
madicrane
Contributor
Contributor
‎2019-06-27 09:37 AM

Qlik Sense

How do I take the sum of one months revenue minus the previous month revenue and create a new field showing negative revenue?

 

I know I need to make a new calculated field just getting a little stuck on the logic. 

 

Thanks,

454 Views
0 Likes
2 Replies
ThePeterK
Creator
Creator
‎2019-06-27 10:06 AM

Might be solved by set analysis. Can you tell us about the structure of the data?
93/93
449 Views
0 Likes
madicrane
Contributor
Contributor
‎2019-06-27 10:08 AM
Author

In response to ThePeterK

Current just an excel sheet I'm messing with that I have uploaded. Very basic structure have the account names and the revenue generated from that account each month. I need to be able to see when our revenue is dropping and highlight those from current month - previous month since most of our contracts our set pricing and just want to be able to quickly analyze when there is a difference. 

447 Views
0 Likes