topic Re: Regarding Filtering data in QlikView

Regarding Filtering data

rathnam_qv — Mon, 14 Apr 2014 05:13:20 GMT

Hi all,

i have 3 straight Tables(ex:A,B,C).My requirement is

1. if i select any value from table A remaining B,C tables should get populate.

2.if i select any value from table B Only table C should get populate and

3. if i select any value from table C remaining A,B tables should get populate.

How to implement this.

can any one help me out.

Thanks in advance!!!

Regards,

Rathnam.

Re: Regarding Filtering data

tresB — Mon, 14 Apr 2014 05:34:10 GMT

May be, you can try showing charts conditionally. Condition could be something like: =GetSelectedCount(YourField)

Re: Regarding Filtering data

cfz — Mon, 14 Apr 2014 05:37:21 GMT

Hi Rathman,

In the layout tab of the properties of the objects there is a show conditional section where you can add an expression reflecting your logic. Please post the qvw so we can give you a more specific answer.

Carlos

Re: Re: Regarding Filtering data

rathnam_qv — Mon, 14 Apr 2014 06:00:01 GMT

Hi Carlos Fernandez,

thanks for your reply.

PFA qvw and send me the solution.

Regards,

Rathnam.

Re: Re: Re: Regarding Filtering data

tresB — Mon, 14 Apr 2014 06:08:50 GMT

May be like attached. Check the expressions for each chart:

Layout tab->Show-> Conditional

Re: Re: Re: Regarding Filtering data

cfz — Mon, 14 Apr 2014 06:16:46 GMT

Hi rathnam,

Please find attached your qvw modified.

I hope it helps.

Carlos

Re: Regarding Filtering data

rathnam_qv — Mon, 14 Apr 2014 06:24:22 GMT

Hi Carlos,

Thanks for your precious time.

but i don't want to hide the charts.

Regards,

Rathnam.

Re: Regarding Filtering data

cfz — Mon, 14 Apr 2014 06:30:54 GMT

Hi Rathnam.

Then instead of using the show conditional option you can put the logic on calculated dimension like

=if(GetSelectedCount(BUSINESS_UNIT)<>0,COST_CENTER_NAME)