Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 - Contributor II
Partner - Contributor II

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

Capture.PNG

View solution in original post

4 Replies
tresesco
MVP
MVP

@HWallays , try something like:

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

Jonathan_Dienst
Partner - Contributor II
Partner - Contributor II

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

Capture.PNG

HWallays
Contributor III
Contributor III
Author

TH

Carlosgonzgar
Contributor
Contributor

I have the same needs. But I try to use that and doesn´t works. When I try to calculate the =Count(Distinct [$(=$Field)]) the system doesn´t understand the chararcters [] and in the object show the formula: =Count(Distinct [(-]). 

I have tried many different ways but when I introduce the $Field in some expressiones (Count, sum, etc...) the system doesn´t understand