Hello All-
Fairly new to Qlikview. Working on a project where we are tracking events that are put into categories (Event Codes). We want to track occurrence of these event codes per month, based on when they were discovered (we have discovery dates, I converted them in the dimension tab to discovery month). I've created a Pivot Table with the various event codes along the left side and the discovery months across the top and it calculated the count of event codes per discovery month. This is great, because it is populating the empty fields with "0" (i.e. we had none of that event code in the month). If I try to make a bar graph, the zeros are obviously not there anymore, because my data source doesn't tell me when something isn't occurring. How can I set up my graphs to accurately display that none of a specific event code was discovered in a particular month?
