Show first data for Dimension based on selection in Qliksense

[bharathkamath28]

Hi @sunny_talwar  @tresesco 

I have a scenario where i have to show only the values of one dimension based on selection.

Ex:

Table1:

ID,Name,Value

1,A,

2,B,

3,C,10

4,D,10

Table2:

ID,Property

1,P1

2,P2

2,P3

3,P4

3,P5

3,P6

4,P7

4,P8

4,P9

4,P10

When the user logins, then the table should show all the properties:

If the user selects column "Value", then the table should return Property related to ID=3

Alphabetically name=C comes first then D, So only properties related to C should be shown.

Thanks,