Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference Between Actual and Plan

Hi, I am a newbie trying out Qlik Sense. My dataset consists of month, year, sales amount, actual or plan indicator.  For example,

Month      Year      Sales Amount     Act_Plan

1               2016     1000                    Actual

1               2016     1100                    Plan

2               2016     1200                    Actual

2               2016     1300                    Plan

Queries:

1. How do I create a measure to show the difference between Month Actual less Month Plan?

2. If I want to chart this, how do I show the Sales Amount for Actual and Plan side-by-side?

Thank you.

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

The app is attached with my earlier reply.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!