topic Re: Inserting a variable into set analysis expression in QlikView

Inserting a variable into set analysis expression

Anonymous — Sun, 18 Mar 2012 12:08:46 GMT

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 ??)

Sun, 18 Mar 2012 12:31:26 GMT

Hi,

Try:

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

Sun, 18 Mar 2012 12:32:49 GMT

Add $ sign and the variable in brackets like below

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

Regards,

Sajeevan

Anonymous — Sun, 18 Mar 2012 12:42:33 GMT

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

I created it with:

vCountry_Name_A = 'United Kingdom'

Sun, 18 Mar 2012 12:46:48 GMT

Forgot to add the curly brackets - try this

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

Anonymous — Sun, 18 Mar 2012 13:02:18 GMT

I have tried that as well, still no luck.

Perhaps I should just not use a variable

Sun, 18 Mar 2012 13:15:09 GMT

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

jonathandienst — Sun, 18 Mar 2012 16:34:02 GMT

Perhaps this

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

Regards

Jonathan

Anonymous — Sun, 18 Mar 2012 16:57:15 GMT

Thanks Jonathan,

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

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