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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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))