Excluded Values in macro bucle

Fri, 04 Jun 2010 23:10:53 GMT

Hi everyone,

Im trying to make a nested FOR structure in a macro so I can match possible values against excluded values of the field "TestResult", the problem is that I make a selection in "year" and "course" fields and then run the macro ; possible values are working fine but the excluded values are takin every course along the entire years list and I only need the excluded values considering only the year.

So the question is: Is there any way to use "GetExcludedValues" considering certain fields only?

I was also trying to make this via variables but they didnt work in the for structure:

for ind1 = 1 to var1 // value of variable "var1" = count (total<year> {$<year=>} teacher)-CountPossible <----Not working either

Thanks in advance

Alfredo

topic Excluded Values in macro bucle in QlikView

Excluded Values in macro bucle