topic Re: Using Variable as Field Name in Set Analysis in QlikView

Using Variable as Field Name in Set Analysis

byrnel0586 — Tue, 19 Mar 2019 21:52:17 GMT

Hi all,

I have a simple set analysis expression that I want to use a variable I created instead of a field name. I can't seem to get it to work. I have looked around the community, but no solutions are working for me.

Variable:

vYearAvgEnrollment = sum(Avg_Enrollment) *do not have the equal sign in variable definition*

Expression:

=COUNT({<$(vYearAvgEnrollment)={">=100"}>}DISTINCT G_CONTRACT_ID)

Any help is appreciated.

Re: Using Variable as Field Name in Set Analysis

Lisa_P — Tue, 19 Mar 2019 22:18:28 GMT

You can't use a variable as a field in set analysis

Re: Using Variable as Field Name in Set Analysis

Vegar — Wed, 20 Mar 2019 10:11:27 GMT

You can only use a variable as a field name if the variable is an field name.

Eg vFieldName = G_CONTRACT_ID

However you should probably be able tp accomplish what you want whith the following expression.

Count({<G_CONTRACT_ID={"=$(vYearAvgEnrollment)>=2000"}>}Distinct G_CONTRACT_ID)

Re: Using Variable as Field Name in Set Analysis

byrnel0586 — Wed, 20 Mar 2019 13:27:54 GMT

That explains why it was not working then 🙂

Thank you, your expression is working for my needs.