Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

Display name of currently selected field along with table name

Hi All ,

I have a QVW with many fields. I want the user to be able to find which table a field belongs to whenever a user makes any selection in that field.

To solve this issue, I created a table box with the dimensions $Field, $Table. But, guess I need to play around with it to achieve the desired functionality

Please have a look at the attached qvw for the problem statement. If I make a selection in the field "Country", I should be able to see only the second row of the table box. If I make a selection in the field "City", I should be able to see row 1 and 3. If I make selections in all fields, I should be able to see all rows of the table box.

I know that the getcurrentselections() function will help, but I was unable to solve the problem.

Thanks,

Neeraj

2 Replies
Highlighted
MVP
MVP

Re: Display name of currently selected field along with table name

I think you were close to getting it.  You can do it with the tools you mention, $Field, $Table and getcurrentselections().  It's just a matter of how to combine the pieces to make the chart you want.  Make a straight table.

Dimension 1 = =if(index(getcurrentselections(),$Field&':'),$Field)
Dimension 2 = $Table

Suppress nulls for dimension 1.  And on the presentation tab, do NOT suppress zero values.  Worked for me, but I'm too lazy to save and then repost the file.  But if you have any trouble, I can go ahead and do that.

Highlighted
Not applicable

Re: Display name of currently selected field along with table name

Thanks a ton John. It works fine.