topic Re: Block chart with equal segment heights/widths in QlikView

Block chart with equal segment heights/widths

immkhan2 — Mon, 28 May 2018 07:05:09 GMT

Gurus,

I want to create block chart with equal height/width irrespective of the proportional of data. I want to have the block in equal sizes.

Regards

Imran

Re: Block chart with equal segment heights/widths

marcus_sommer — Mon, 28 May 2018 07:54:01 GMT

You could try it with an expression like: dual(num(YourExpression, Format), 1)

- Marcus

Re: Block chart with equal segment heights/widths

uacg0009 — Mon, 28 May 2018 10:01:53 GMT

Hi Khan,

If the below table is also ok for you :

You can try to use Funnel Chart, the setting is like below:

Important thing is Tip Width% = 99 and Equal Segment Heights.

You can see my attachment.

Thanks.

Aiolos

Re: Block chart with equal segment heights/widths

immkhan2 — Thu, 31 May 2018 13:47:36 GMT

This solves my problem but now an additional 0(0) is coming which is not in the data.

Re: Block chart with equal segment heights/widths

marcus_sommer — Thu, 31 May 2018 13:58:34 GMT

Go to the tab dimensions and enable the surpressing of null-values for your dimension.

- Marcus

Re: Block chart with equal segment heights/widths

immkhan2 — Thu, 31 May 2018 14:34:03 GMT

I have already marked this checkbox but still it is displaying zero.

Thanks & Regards

Re: Block chart with equal segment heights/widths

marcus_sommer — Thu, 31 May 2018 17:46:36 GMT

Then you could try to NULL it either with a condition within your origin expression or by checking their result, maybe with something like this:

dual(num(YourExpression, Format), if(YourExpression= 0, null(), 1))

- Marcus

Re: Block chart with equal segment heights/widths

immkhan2 — Sun, 03 Jun 2018 09:19:14 GMT

Now it solves the problem but new problem arise. Now text is not coming complete.

Thanks & Regards

Re: Block chart with equal segment heights/widths

immkhan2 — Sun, 03 Jun 2018 09:30:37 GMT

sorry Text is coming Incomplete.

Re: Block chart with equal segment heights/widths

marcus_sommer — Mon, 04 Jun 2018 07:24:17 GMT

It is just meaning that there is not enough space to display the complete text. I don't know if there is any way to force in which way the blocks are displayed in regard to their lengths and heights but I doubt that it will be possible.

So the simplest way would be to size the chart a bit larger so that it fits to lengths of the text. If not you could try to move the expression to the dimension and using then just 1 as expression - here an example what is meant:

=dual('texttttt ' & chr(10) & '(' & aggr(count(RowNo), RowNo) & ')', RowNo)

and in tab presenation only enabling to display the dimension-values resulted in a complete configurable string like:

- Marcus