I'm trying to create a chart using data like this...
The resulting histogram looks like this (Qlikview)...
But I want it to look like this (Excel)...
The problem: I want to show all of the Attainment values from 0% to 20%. Is there a way to force the dimension axis to show a list of values even if those values aren't represented in your data? I've tried using a continuous axis, but it causes the bars to overlap.
Thanks for the response. Your suggestion definitely works, but I'm afraid it's not feasible for me. I'm using very large data sets and it would be impractical and messy for me to create that many empty records across all relevant dimensions.
As this is a display issue (as opposed to, say, a calculation issue), it's sad to think that the solution would require me to change the data.
One simple solution would be create one inline table line this :
load * inline
since the Attainment field name is common both the fields will get linked and not you can in the chart properties you need to uncheck the upress zero values and check populate zero values this is give your desired result