Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
kshitijas
Not applicable

Selection in filter pane

Hi Everyone,

1.S1.PNG2.S2.PNG  

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


12 Replies
yoganantha321
Not applicable

Re: Selection in filter pane

Hi kshitijas,

While extracting Cust_ledger entry no from the data source kindly do query operation of group by Document no.

by using this way you achieve it easily

kshitijas
Not applicable

Re: Selection in filter pane

Hi Yoganantha,

Can you explain in detail  what exactly has to be done.

Thanks in advance

yoganantha321
Not applicable

Re: Selection in filter pane

Hi Kshitijia,

you extracting the cust_ledger entry no field from any of the data source while extracting that give a statement like group by Document_no.

So that while selecting the document_no it will highlight all cust_ledger_entry_no associated with it.

Example I have given below:

LOAD document_no,

  cust_ledger_entry_no,

From data source

Group by document_no,cust_ledger_entry_no;

like this............

kshitijas
Not applicable

Re: Selection in filter pane

As i am working on the DB i dont have that FROM data source line in my table.

vinieme12
Not applicable

Re: Selection in filter pane

what do you want to get 3 entries of and why?

Customer_No to Document number looks like a one to many relationship where do you want to have 3 entries?

yoganantha321
Not applicable

Re: Selection in filter pane

Hi Kshitijia,

I am sure you can achieve it by grouping but I dont know how to give the source

kshitijas
Not applicable

Re: Selection in filter pane

On the selection of Document number i want 3 entries in Cust_Ledger entry no

vinieme12
Not applicable

Re: Selection in filter pane

That is what I'm trying to understand if one document relates to one customer ledger how will you get 3 possible values in customer ledger?

kshitijas
Not applicable

Re: Selection in filter pane

But if you select that same Cust_legder entry no. you get 3 document entries