topic Re: Need Urgent help plzz.. block chart in QlikView

Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:30:39 GMT

Hi All,

I have to create a Block chart but i want to maintain the equal width for all the blocks.. but the block chart is spilitting the block into different block sizes.

Thanks in advance..

Any suggestions are much appreciated..

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:36:33 GMT

So you want the blocks to be of equal widths, and only have different heights?

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:40:23 GMT

Sorry i want equal width and height both.. basically same bloack area for all the blocks..

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:42:04 GMT

I think the only way to be able to do that is if whatever expression you're using produces the same value for each dimension, otherwise the blocks size according to the relative values of the expression.

Perhaps another type of visualization could be helpful? What are you trying to do?

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:42:54 GMT

You could take groups of text boxes and lay them together, maybe as an alternative?

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:48:25 GMT

Actually my expression is 1 so in that case all my blocks should be of equal size... the requirement that i need to do is something like the block chart.. so i have started doing that.. if you any ideas please share...

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:50:29 GMT

Could you share a sample qvw? I'm playing with an example now, and you can get them to all be the same size by resizing the chart area

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 16:59:05 GMT

Really sorry to say that the data i have is highly confidential.. i am attaching an image of it.. Thanks very much for your help.. could you please try to post your coments based on the attachment i have provided..

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 17:02:27 GMT

Honestly, with a block chart and that many blocks I think it may be nearly impossible to get them to all be the same size. Using text boxes to do something similar is a good option. Or maybe some other way would be possible too.

Are you just trying to show the names of all the fields in a somewhat appealing way? Why is a block chart necessary?

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 17:06:44 GMT

Actually i have the other aggregations are will be soon added to the chart.,. but my intension is to get the equal block size so that i can add my calculations at the next point.. i can make text objects but that way of implementation i s not recommended here ..

may i know if there is anyother way of representing the data in equal blocks?

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 17:14:03 GMT

So you want them to all be of equal size so you can then add another expression to the chart?

Another expression will most certainly change the size of your original blocks. I'm sorry, but what you're requesting is either not possible or you'll need to provide some more info to be clearer

Re: Need Urgent help plzz.. block chart

Wed, 02 Jul 2014 17:51:21 GMT

Is Block chart a mandatory as we dont have the option of equal height/width in Block. It could be possible with a funnel chart instead but not sure if you can change the chart. If the volume of data is more then most of the blocks look similar.

Re: Need Urgent help plzz.. block chart

Greg_Williams — Wed, 02 Jul 2014 18:04:35 GMT

I haven't seen the done before, perhaps you wish to try a stacked bar?