Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greeting,
I am looking to create a block chart based on fields with string information. Each field would also have multiple string values attached to them. Additionally, I will make a similar chart with a dependency to that previous chart. Could anyone assist me or direct me to someone/youtube clip with appropriate information. the intended design will be something like the image below where a,b, c are the categories, and a,z,y,w,f are fields under those categories.
Thank you in advance.
I'm not sure any of these are exactly what you want, but here are a few options.
Not sure what you are trying to achieve.
Could you upload some sample records and the requested outcome?
Your table above looks to me as we could maybe achieve what you want using a pivot table chart.
a | x |
a | z |
a | x |
a | z |
a | x |
a | z |
a | x |
a | z |
a | x |
a | z |
a | x |
a | z |
a | x |
b | y |
b | z |
b | f |
b | x |
b | y |
b | z |
b | f |
b | x |
b | y |
b | z |
b | f |
c | w |
c | w |
c | w |
c | w |
c | w |
c | w |
c | w |
c | w |
So, Its like a pivot table but I want to be able to drill down from it even further and have boxes to make it more visually appealing than lines on a graph..
A drill down can be accomplished using a drill down group as dimension, for both pivot tables and block charts.
Seems like you want to show categories and subcategories same time. You can maybe achieve this, but I don't think that you can control the layout of the block chart to show certain (child) blocks under another (parent) block.
Or maybe I am just missing something here.
Yes! exactly! I want to show a chart with a parent category, child category and then a grandchild category eventually. Then upon click one of the grandchild categories a list of another category shows up, and then that directly populates a straight data chart with the relevant detailed information.
I'm also stuck on what expressions I should use to do this to show the hierarchy.
I feel like I'm missing something as well. Showing categories and subcategories at the same time just means using two dimensions in your block chart? Adding a third dimension technically works as well, but QlikView doesn't seem to know how to label everything, so it doesn't look very good.
If you're trying to drill through instead of seeing them at the same time, a drill down group as your dimension would do that.
by using the sort to the sort the columns
Here's a better data set and I've attached a screenshot of what I am trying to accomplish in Qlikview. I did it Spotfire, but I can't see if Qlikview has the same capabilities.
Products | Entity Type | Businesses |
Drums | a | x |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | a | z |
Drums | a | x |
Drums | b | y |
Drums | b | z |
Drums | b | f |
Drums | b | x |
Drums | b | y |
Drums | b | z |
Drums | b | f |
Drums | b | x |
Drums | b | y |
Drums | b | z |
Drums | b | f |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Drums | c | w |
Trumpets | a | x |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | a | z |
Trumpets | a | x |
Trumpets | b | y |
Trumpets | b | z |
Trumpets | b | f |
Trumpets | b | x |
Trumpets | b | y |
Trumpets | b | z |
Trumpets | b | f |
Trumpets | b | x |
Trumpets | b | y |
Trumpets | b | z |
Trumpets | b | f |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Trumpets | c | w |
Ultimately, I am using the block charts as a from of filter.