topic Re: Variable expressions in set analysis in QlikView

Variable expressions in set analysis

Fri, 05 Feb 2016 16:17:30 GMT

Hi ;

I have 2 variables (vMaxWeek) and (vMaxWeek_3). The variables are correct are pulling values.

I then wrote this set analysis expression:

=sum( {<[WeekNumber] = {>=$(vMaxWeek) <= $(vMaxWeek_3)}>} loadingDuration).

The result is not correct.

Please assist.

Fri, 05 Feb 2016 18:31:35 GMT

try to use ' ', something like:

=sum( {<[WeekNumber] = {'>=$(vMaxWeek) <= $(vMaxWeek_3)'}>} loadingDuration)

instead of

=sum( {<[WeekNumber] = {>=$(vMaxWeek) <= $(vMaxWeek_3)}>} loadingDuration)

for my example, it worked

petter — Fri, 05 Feb 2016 18:35:20 GMT

You must enclose the search in double-quotes like this:

=sum( {<[WeekNumber] = {">=$(vMaxWeek) <= $(vMaxWeek_3)"}>} loadingDuration)

petter — Fri, 05 Feb 2016 18:36:45 GMT

Furthermore the variables might have to be evaluated depending what is in them - constants or expressions.

So you might have to write:

=sum( {<[WeekNumber] = {>=$(=vMaxWeek) <= $(=vMaxWeek_3)}>} loadingDuration).