Block Chart

[bharatkishore]

Hi All,

I have the following 2 block charts. When ever i open the qvw the default will be as below:

Now my requirement is, the default view of the right block chart should be only displayed current(not with all the values) i .e. below image for your reference:

Then if i click on the various number in left block chart the right block chart numbers will be  displayed as below

.

But my default view should be only with current not with all the numbers in right block chart

Expression i have written is

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

fabs((sum( if(isnull([Clrng doc]), [LC2 Amount])))))

Calulated dimension is

=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)]).

Can you please help me on this.

Thanks,

Bharat

[kaushiknsolanki]

HI,

Kindly share your application with sample data.

Regards,

Kaushik Solanki

[bharatkishore]

Hi Kaushik,

PFA app...

Thanks,

Bharat

[settu_periasamy · Accepted solution]

Hi,

Check the Attachment

[bharatkishore]

Thanks a lot...Thank you so much.

Thanks,

Bharat