problem with line graph with 0 value or no position (is this a bug in qlikview, or can qlikview not show the graph in the form I want to show)??))
Hi,
attached there is a document with two line graphs.
The graph at the beginning of the document has the form that I want to use, but when I filter my data that I have only selected two months (as example Feb and Mar) then in the graph the other months are also visible (the reason is because the flag "listen all values" in register Dimension is selected. But if this flag is not set, then the data is displayed as in the graph at the end of the document.
Do anybody know a solution for my problem, or is it not possible to show the graph in this form I want to show it.
Many thanks for all answers, I have tried it hours, but I do not find a good solution.
I can see how that would work if your data table was only month and value. But we also have customer. so I'd think you'd need to preload 0 into every possible combination of month and customer. For a more realistic data table with, say, 20 fields, you'd have to preload 0 into every possible combination of all 20 fields, which could easily be memory and load time prohibitive. Also, maybe I'm doing it poorly, but it seemed complicated when I tried to do it in practice. See attached.
