Re: Selection in filter pane - Page 2 - Qlik Community

Karahs · ‎2017-03-22

Hi Everyone,

1.2.

As per the above image:

I have two filters Document no and Cust_ledger...

In image1 if i select document no only one Cust_ledger entry no gets selected and

In image 2 if i select that same Cust_ledger entry no it gives me 3 entries of document no.

But i need to select document no and get 3 entries. How can i do that?

Thanks in advance

vinieme12 · ‎2017-03-22

Because it's a One to Many Relationship

meaning one customerledger may have more than one documents, but one document is only associated to one customer ledger

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Karahs · ‎2017-03-23

Hi Vineeth,

I understand what you want to tell, but is there any way that i can get the selection in that way?

Regards,

viveksingh · ‎2017-03-23

there may be source, without knowing the source you cannot do any thing.

my suggestion is to load into a table and in resident you can use Group by.

and drop the old table