Use a variable in set analysis

[#1]

In the following I want to replace the expression FORT_BENENNUNG= with a variable.

=count({<FORT_BENENNUNG=>} distinct FGN_AV)

I defined the variable in an input box as:

vFORT_BENENNUNG) =   FORT_BENENNUNG=

I cannot bring the expression with the variable to work

=count({<$(vFORT_BENENNUNG)>} distinct FGN_Fahrzeug) result 0

=count({<$(=vFORT_BENENNUNG)>} distinct FGN_AV):  this ignores the set analysis

=count({<{$("vFORT_BENENNUNG)"}>} distinct FGN_AV) : no result ( -)

and other different expressions, which all did not work.

i would be happy if i could get a solutiom. Thank you in advance.

(The variable in my application is much more complex, the example posted here is simplified)

[jsenivifor]

Hello,

To define the variable in the script:

      vFORT_BENENNUNG = " FORT_BENENNUNG =" ;

and the set of analysis :

=count({<$(vFORT_BENENNUNG )>} distinct FGN_AV)

Good Luck with QV!

[marcus_sommer]

This syntax: =count({<$(vFORT_BENENNUNG)>} distinct FGN_Fahrzeug) looked right. Are you sure that the result must be different to 0? How is the variable defined and how looked they within a textbox?

If you you used such expression within a table-chart and you set no label you could see within the label (per mouseover) how qlik interpreted the the expression-parts.

- Marcus

[#4]

Thank you for your answer.

Unfortunately I don't have the possibility to make changes in the script.

I have to define the variable in an Input box.

vFORT_BENENNUNG = " FORT_BENENNUNG =" in the input box doesn't work

=count({<$(vFORT_BENENNUNG )>} distinct FGN_AV): result =0

The expression:

=count({<FORT_BENENNUNG=>} distinct FGN_AV)

gives the right result (the result is independent from the filtering in field FORT_BENENNUNG)

[#5]

Thank you for your answer.

I defined the variable in an input box as:

vFORT_BENENNUNG =   FORT_BENENNUNG=

=count({<$(vFORT_BENENNUNG )>} distinct FGN_AV)

should bring the same result as

count({<FORT_BENENNUNG=>} distinct FGN_AV)

but does not.

[jsenivifor]

Hello,

This  is what you need?

[marcus_sommer · Accepted solution]

Only to clarify - the variable-definition must not start with the equal-sign, only:

variable vFORT_BENENNUNG:

FORT_BENENNUNG=

and then I see that there is a space behind your variable and the bracket:

$(vFORT_BENENNUNG )

- Marcus

[#8]

Thank you very much for your help. After eliminating the space in the bracket and correcting the variable as you showed me, the expression works correctly.

[#9]

Hello

My problem was solved by Marcus Sommer.

Thanks to you also for your efforts and answer.