topic Re: Block Chart Positive and negative numbers in QlikView

Block Chart Positive and negative numbers

bharatkishore — Sat, 02 Apr 2016 06:16:21 GMT

Hi All,

I have created a block and there are positive and negative numbers. When this happens my block chart becomes like this..Image shown below

Numbers image for your reference:

If i use fabs only positive values are coming but i need to display negative values also.

Expression i have written is

=(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'))

Can you please help me how to get the negative numbers also.

Thanks,

Bharat

Re: Block Chart Positive and negative numbers

maniram23 — Sat, 02 Apr 2016 06:40:58 GMT

Hi,

Block chart is not allow the Negative '-' values.

=fabs(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00')))

you can try this one.

you will get the positive & negative values. but here it will not show the '-' negative symbal.

Re: Block Chart Positive and negative numbers

Kushal_Chawda — Sat, 02 Apr 2016 06:41:46 GMT

create two expression in block chart, first with fabs & second without fabs

1) fabs(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'))

2) num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00')

Re: Block Chart Positive and negative numbers

maniram23 — Sat, 02 Apr 2016 06:58:13 GMT

kush,

I tried your logic but I am not getting the values.

can you share the example.

Re: Block Chart Positive and negative numbers

Kushal_Chawda — Sat, 02 Apr 2016 07:17:49 GMT

As this works for pie chart, I thought it should work for Block too, but it's not working. Need to look for another solution

Re: Block Chart Positive and negative numbers

bharatkishore — Sat, 02 Apr 2016 07:31:03 GMT

thanks for your reply mani.. I have tried this expression but in Block chart even the negative numbers are not displaying even without symbol...Can you please tell me how can i display those negative numbers also..

Re: Block Chart Positive and negative numbers

Kushal_Chawda — Sat, 02 Apr 2016 08:18:48 GMT

It's good that you got the solution but not exactly.

Here is how you will get the negative number on block chart.

Re: Block Chart Positive and negative numbers

bharatkishore — Sat, 02 Apr 2016 09:20:43 GMT

Thanks Kush.. Can you please send the test file... so that i can go through it and also please let me know what expressions i need to write..

Re: Block Chart Positive and negative numbers

Kushal_Chawda — Sat, 02 Apr 2016 10:39:40 GMT

use the below expression

Dual (num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'),fabs(sum(if(isnull([Clrng doc]), [LC2 Amount]))))

Re: Block Chart Positive and negative numbers

bharatkishore — Sun, 03 Apr 2016 04:52:47 GMT

thanks Kush...