Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Block Charts with string information

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.

Capture.PNG

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

I'm not sure any of these are exactly what you want, but here are a few options.

View solution in original post

10 Replies
swuehl
MVP
MVP

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.

Not applicable
Author

ax
az
ax
az
ax
az
ax
az
ax
az
ax
az
ax
by
bz
bf
bx
by
bz
bf
bx
by
bz
bf
cw
cw
cw
cw
cw
cw
cw
cw
Not applicable
Author

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..

swuehl
MVP
MVP

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.

Not applicable
Author

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.

johnw
Champion III
Champion III

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.

Anonymous
Not applicable
Author

by using the sort to the sort the columns

Not applicable
Author

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.qlikview example.PNG

   

ProductsEntity TypeBusinesses
Drumsax
Drumsax
Drumsaz
Drumsax
Drumsaz
Drumsax
Drumsaz
Drumsax
Drumsaz
Drumsax
Drumsaz
Drumsax
Drumsaz
Drumsax
Drumsby
Drumsbz
Drumsbf
Drumsbx
Drumsby
Drumsbz
Drumsbf
Drumsbx
Drumsby
Drumsbz
Drumsbf
Drumscw
Drumscw
Drumscw
Drumscw
Drumscw
Drumscw
Drumscw
Drumscw
Trumpetsax
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsaz
Trumpetsax
Trumpetsby
Trumpetsbz
Trumpetsbf
Trumpetsbx
Trumpetsby
Trumpetsbz
Trumpetsbf
Trumpetsbx
Trumpetsby
Trumpetsbz
Trumpetsbf
Trumpetscw
Trumpetscw
Trumpetscw
Trumpetscw
Trumpetscw
Trumpetscw
Trumpetscw
Trumpetscw
Not applicable
Author

Ultimately, I am using the block charts as a from of filter.