topic Re: Block Chart Numbers in QlikView

Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 06:39:00 GMT

Hi All,

I have block chart. And below image for your reference

Here you can see in the image that i am missing numbers instead of 91 i am getting as (1-120),instead of 151 i am getting as(51-180).. Can you please tell me how can i get the missing numbers.

Expression i have written for calculated dimension is:

=SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&SubField([Ageing Buckets(Due in)],'in',-1)&chr(10)

Thanks,

R. Bharat Kishore

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 07:07:48 GMT

Hi Bharat,

Can you post your [Ageing Buckets(Due in)] Values?

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 07:10:26 GMT

Hi Samy,

Please find the below image for the ageing bucket due in values...

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 07:17:36 GMT

Hi,

Try this..

=if(WildMatch([Ageing Buckets(Due in)],'*in*'),
SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&SubField([Ageing Buckets(Due in)],'in',-1),[Ageing Buckets(Due in)])

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 07:20:43 GMT

Thanks a lot Samy.. worked like a gem... I have one more query...I am not able to see full values.. Can i see the full values as well. Below image for your reference.

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 07:31:15 GMT

May be you can try with one more New Line (i.e chr(10) )

=if(WildMatch([Ageing Buckets(Due in)],'*in*'),
SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&

SubField([Ageing Buckets(Due in)],'in',-1)&chr(10),[Ageing Buckets(Due in)])

But, i'm not sure, because some of the values of the square box is very small.

You can try increase the chart also.

Re: Block Chart Numbers

Chanty4u — Wed, 30 Mar 2016 07:34:01 GMT

use chr(10) in ur expression

='Text: ' & Concat(urfield ,',')

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 07:37:32 GMT

I have tried by expanding the char and even given chr(10) but still i am not getting...Anything am i missing

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 07:40:46 GMT

Is it possible to provide the sample? Let me try it

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 07:58:41 GMT

Hi Samy,

Please find the attached app...

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 08:14:42 GMT

46 MB?? Can you reduce and post ?

Let me try to create a sample..

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 08:52:15 GMT

Can you please tell me how to reduce the size...

Re: Block Chart Numbers

Chanty4u — Wed, 30 Mar 2016 08:55:34 GMT

first take a copy of ur qvw.

comment which not required in script

and delete all the objects in the sheet and place only this chart and upload.

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 08:58:52 GMT

That is what i have done chanty...Nohing will be there

Re: Block Chart Numbers

Chanty4u — Wed, 30 Mar 2016 09:04:00 GMT

then do this

goto file menu-> Reduce Data -> keep possible values

it reduce ur qvw file

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 09:09:20 GMT

Hi Bharat,

I downloaded the file. But not able to open it. I think your file having SECTION ACCESS.

Leave it. Let me try it my own example..

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 09:10:05 GMT

Yes chanty even i have tried that one then whats happening is even the chart values are also going... blank chart...

Re: Block Chart Numbers

bharatkishore — Wed, 30 Mar 2016 09:11:33 GMT

I am really sorry samy.. I have removed the section access shall i send again...

Re: Block Chart Numbers

Chanty4u — Wed, 30 Mar 2016 09:12:23 GMT

give him Id and password man.....otherwise it will take so much time to download

Re: Block Chart Numbers

settu_periasamy — Wed, 30 Mar 2016 09:50:31 GMT

Bit changed in the Calculated Dimension.. Try this..

=if(WildMatch([Ageing Buckets(Due in)],'*in*'),
SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&SubField([Ageing Buckets(Due in)],'in',-1)&chr(10),
[Ageing Buckets(Due in)]&chr(10))