Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a chart using data like this...
ID | Attainment |
---|---|
1001 | 2% |
1002 | 5% |
1003 | 5% |
1004 | 16% |
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.
I know this is late but I stumbled on your post here looking for something else.
You need add "empty" data for the Attainment percentages that you are missing. See attached example.
Good luck!
Johan
Hi Johan,
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.
Just create the dummy data from 1% to 20% and join with attainment.
On the Bar chart , uncheck supress zero values option.
Yes.
Probably event better to make a small table with the twenty dummy-rows and then concatenate the big table.
/Johan
Hi Johan
I have similar requirement, I want to show last 18 month on X Axis. Can you suggest something on this?
Hi Mark,
One simple solution would be create one inline table line this :
load * inline
[
Attainment
1%
2%
etc
];
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