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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Amit_B
Creator II
Creator II

Show value list for the fields

Hi everyone,

I have a table that contain the names of all the tables in the model ($Table) and all the fields in the model ($Field).

I need to do the following:
1. Add a column that shows 5-10 sample distinct values for each field.
2. When a field is selected (from $Field column), I want to display a list of all distinct values that exist in that field, shown in a separate object (in table for example).

Is there a way to achieve this?

Thanks!

Labels (4)
1 Reply
Chanty4u
MVP
MVP

Hi try this 

For distinct 

=Concat(DISTINCT P( [$Field] ), ', ', 10)

Then create a variable 

=$(vSelectedField)

 

Then 

=Concat(DISTINCT $(vSelectedField), ', ') to display values or metrics.