Block Chart Numbers

[bharatkishore]

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

[settu_periasamy]

46 MB??  Can you reduce and post ?

Let me try to create a sample..

[bharatkishore]

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

[Chanty4u]

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.

[bharatkishore]

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

[Chanty4u]

then do this

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

it reduce ur qvw file

[settu_periasamy]

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

[bharatkishore]

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

[bharatkishore]

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

[Chanty4u]

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

[settu_periasamy]

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