Inserting a variable into set analysis expression

[Anonymous]

I am trying to have a set analysis expression that is dynamic for the country name.

Hence I want to manipulate the following expression

=num(count(distinct {<CountryName ={'United Kingdom'}>}SeriesRaceEventKey),'#,##0')

I have made a variable called vCountry but inserting this into the expression does not work.

The script editor says "Expression OK" but the result is blank.

=num(count(distinct {<CountryName =vCountry_Name_A>}SeriesRaceEventKey),'#,##0')

Am I using the wrong syntax? (If I am the script editor would indicate this as a Bad Expression ??)

[#2]

Hi,

Try:

=num(count(distinct {<CountryName =$(vCountry_Name_A)>}SeriesRaceEventKey),'#,##0')

[#3]

Add $ sign and the variable in brackets like below

=num(count(distinct {<CountryName =$(vCountry_Name_A)>}SeriesRaceEventKey),'#,##0')

Regards,

Sajeevan

[Anonymous]

Tired that but no luck. Perhaps it is the way I defined the variable?

I created it with:

vCountry_Name_A    = 'United Kingdom'

[#5]

Forgot to add the curly brackets - try this

=num(count(distinct {<CountryName ={$(vCountry_Name_A)}>}SeriesRaceEventKey),'#,##0')

[Anonymous]

I have tried that as well, still no luck.

Perhaps I should just not use a variable

[#7]

Can you attach a sample QV file? There is no harm in using a variable.

[jonathandienst · Accepted solution]

Hi

Perhaps this

=count({<CountryName ={'$(vCountry_Name_A)'}>} distinct SeriesRaceEventKey)

Regards

Jonathan

[Anonymous]

Thanks Jonathan,

This works, strange solution that I would not have guessed.

I presume this is a sort of bug in QV....