topic subfield function with getselectedcount in QlikView

subfield function with getselectedcount

Fri, 16 Apr 2010 17:40:46 GMT

Hi all,

Where the variables have the following values:

vItemOpts = 'fieldname1;fieldname2;fieldname3'

vCurrOpt = 2

This expression in a text object returns the string 'fieldname2'

=SubField(vItemOpts, ';', vCurrOpt)

and where the field 'fieldname2' is used in a list box and has 1 value selected, this returns the value 1

=GetSelectedCount(fieldname2)

but this combination of the two returns null:

=GetSelectedCount(SubField(vItemOpts, ';', vCurrOpt))

Is this because GetSelectedCount sees the string 'SubField....' as a fieldname? How can I get around this?

Regards,

Gordon

subfield function with getselectedcount

johnw — Fri, 16 Apr 2010 21:49:11 GMT

Subfield() returns a string, so your expression probably gets evaluated like this:

=GetSelectedCount(SubField(vItemOpts, ';', vCurrOpt))
=GetSelectedCount('fieldname2')
=null (because you can't get selections for a string, only for a field, and it doesn't recognize it as a field)

I'm not thinking of how to tell it that you mean a field name instead of a string, assuming I even have the problem correct. There's got to be a way, though. Maybe something with dollar sign expansions, variables, or who knows what.

subfield function with getselectedcount

rwunderlich — Sat, 17 Apr 2010 01:33:31 GMT

I think John's on the right track. You just need to add some indirection using another variable.

SET vItemOpts = 'fieldname1;fieldname2;fieldname3';
SET vCurrOpt = 2;
SET vField = "=SubField(vItemOpts, ';', vCurrOpt)";

and then use the expression:

=GetSelectedCount($(vField))

-Rob

subfield function with getselectedcount

Mon, 19 Apr 2010 09:28:01 GMT

Thanks Rob, John - that cracked it!

Regards,

Gordon