Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Giddyap
Contributor
Contributor

Show table 2 only when one row in table 1 is selected

Dear Sirs

I have two straight tables. They're linked properly and work fine as parent/child. Table 2 (child) shows details from one row in Table 1 (parent).

However, when NO rows in Table 1 are selected, Table 2 is irrelevant and messy, as it shows details from all the (non-selected) rows in Table 1. 

How can I make Table 2 show details ONLY when ONE certain row in Table 1 is selected?

 

Thank you.

Kind Regards

/Morten

Labels (1)
1 Reply
Anil_Babu_Samineni

In Table 1, If you have plenty of dimensions, Please create Composite key and the composite key you can use in condition.

Ex, In table 1 you have F1, F2, F3 ...

I would prefer to create it F1&F2&F3 as Key

 

And in Table 2, Add on I will use like

If(GetSelectedCount(Key)>0, 1, 0)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful