Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Don't show totals by month

How can I get my table to show Total Counted for every month and needed only in totals?

2019-08-05_13-25-56.jpg

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

10 Replies
Frank_Hartmann
Master II
Master II

can u share the qvw or at least the raw data to replicate the issue?

cbaqir
Specialist II
Specialist II
Author

Attached

2 sheets - one with data the second sheet (Targets) is how the needed column is calculated

Frank_Hartmann
Master II
Master II

maybe like attached

 

Frank_Hartmann
Master II
Master II

or like attached!

cbaqir
Specialist II
Specialist II
Author

This is a better file. The Needed column is calculated by taking the Targets from the Targets sheet and subtracting the number of appointments.

Frank_Hartmann
Master II
Master II

but then Needed Column for Senior60+ is negative!?!

Or did i misunderstand something?

cbaqir
Specialist II
Specialist II
Author

2019-08-05_13-18-05.jpgThis is what I am trying to replicate

cbaqir
Specialist II
Specialist II
Author

Each person has the targets for the calendar year

cbaqir
Specialist II
Specialist II
Author

2019-08-05_13-25-56.jpg