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
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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: 
WiscoSippi
Creator
Creator
‎2019-08-30 01:22 PM

Counting across date dimension

Hello!

I'm trying to generate a table or bar graph that shows the backlog (Total Bookings - Total Shipments) based on the Ship Date.

This is how my table is structured:

ProjectDate Project CreatedDate Actual Ship
GT-0037311/24/095/14/10
GT-0037411/24/096/02/10
GT-0037511/24/096/08/10
GT-001283/25/092/13/12
GT-007287/03/118/04/12
GT-001293/25/093/14/13

 

This is approximately how I want the visual to look:

5/14/104
6/02/103
6/08/102
2/13/122
8/04/121
3/14/130

 

Any suggestions?

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” — Antoine de Saint-Exupéry
Labels (4)
616 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2019-08-30 10:45 PM

Better If you could explain logic behind to get numbers?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
582 Views
0 Likes