topic Re: Block Charts with string information in QlikView

Block Charts with string information

Wed, 24 Feb 2016 21:45:09 GMT

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.

Re: Block Charts with string information

swuehl — Wed, 24 Feb 2016 22:29:23 GMT

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.

Re: Block Charts with string information

Wed, 24 Feb 2016 22:44:07 GMT

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

Re: Block Charts with string information

Wed, 24 Feb 2016 22:45:57 GMT

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

Re: Block Charts with string information

swuehl — Wed, 24 Feb 2016 23:15:40 GMT

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.

Re: Block Charts with string information

Wed, 24 Feb 2016 23:21:01 GMT

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.

Re: Block Charts with string information

johnw — Thu, 25 Feb 2016 00:05:48 GMT

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.

Re: Block Charts with string information

Anonymous — Thu, 25 Feb 2016 04:56:44 GMT

by using the sort to the sort the columns

Re: Block Charts with string information

Thu, 25 Feb 2016 14:20:59 GMT

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

Re: Block Charts with string information

Thu, 25 Feb 2016 14:33:28 GMT

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

Re: Block Charts with string information

johnw — Thu, 25 Feb 2016 16:55:05 GMT

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

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

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

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