topic Re: Use $Field - content instead of $ Field name in QlikView

Use $Field - content instead of $ Field name

HWallays — Wed, 25 Nov 2020 16:16:04 GMT

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 …

Re: Use $Field - content instead of $ Field name

tresB — Fri, 11 Sep 2020 11:17:59 GMT

@HWallays , try something like:

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

Re: Use $Field - content instead of $ Field name

Jonathan_Dienst — Fri, 11 Sep 2020 11:51:47 GMT

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

Re: Use $Field - content instead of $ Field name

HWallays — Fri, 11 Sep 2020 12:13:27 GMT

Re: Use $Field - content instead of $ Field name

Carlosgonzgar — Fri, 24 Nov 2023 12:20:46 GMT

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