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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Line Graph Help

Hey guys,

I have a line graph that I am trying to show items produced per month. Currently it only shows Jan through September because we haven't collected any data for the rest of the year (Oct, Nov, Dec). I was curious to see how I can get those months to show up anyways with no data collected so far. Here is the current formula I am using to show the total per month.

Sum({$<Program_Dash={'Mechanical Inspection'}, Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>} Processed_Dash)

22 Replies
mostwanted123
Creator
Creator

Can you share the excel file ?

joshrussin
Creator III
Creator III
Author

There is no data passed today in the log.

joshrussin
Creator III
Creator III
Author

I tried this as well, didn't work.



=Sum(If(ISNULL(Processed_Dash),0,Processed_Dash))