Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
HWallays
Contributor III
Contributor III

Use $Field - content instead of $ Field name

I've build a list box shiwng the felds in the model by $Field.

Is there a way to use $Field in the visualisation so that it does not show the name of the field but the actual contents of that field … something like $($Field) or a specific function/formula ? 

 

Why : I would like to make visualisation /  statistics on population/content of the field(s) that I select in the list box; having to make only 1 set of visualisations  instead of making measurements/visualisation per field …

 

  

1 Solution

Accepted Solutions
Jonathan_Dienst
Partner
Partner

i use =Count(Distinct [$(=$Field)]) for this purpose:

Capture.PNG

View solution in original post

3 Replies
tresesco
MVP
MVP

@HWallays , try something like:

=Count( $(='['&$Field&']') )

Jonathan_Dienst
Partner
Partner

i use =Count(Distinct [$(=$Field)]) for this purpose:

Capture.PNG

View solution in original post

HWallays
Contributor III
Contributor III
Author

TH