Block Chart

bharatkishore — Mon, 04 Apr 2016 09:09:53 GMT

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

Re: Block Chart

kaushiknsolanki — Mon, 04 Apr 2016 09:27:34 GMT

HI,

Kindly share your application with sample data.

Regards,

Kaushik Solanki

Re: Block Chart

bharatkishore — Mon, 04 Apr 2016 09:41:42 GMT

Hi Kaushik,

PFA app...

Thanks,

Bharat

Re: Block Chart

settu_periasamy — Mon, 04 Apr 2016 10:01:58 GMT

Hi,

Check the Attachment

Re: Block Chart

bharatkishore — Mon, 04 Apr 2016 10:20:40 GMT

Thanks a lot...Thank you so much.

Thanks,

Bharat

topic Re: Block Chart in QlikView

Block Chart

Re: Block Chart

Re: Block Chart

Re: Block Chart

Re: Block Chart