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

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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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,

877 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
872 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. 

870 Views
0 Likes