topic Re: Qlik Sense in App Development

Qlik Sense

madicrane — Thu, 27 Jun 2019 13:37:15 GMT

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,

Re: Qlik Sense

ThePeterK — Thu, 27 Jun 2019 14:06:04 GMT

Might be solved by set analysis. Can you tell us about the structure of the data?

Re: Qlik Sense

madicrane — Thu, 27 Jun 2019 14:08:22 GMT

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.