topic subfield 2 parameter problem on QV9 SR7 in QlikView

subfield 2 parameter problem on QV9 SR7

rbecher — Wed, 27 Apr 2011 21:57:53 GMT

Hi,

this is an obvious (for me a major) bug in v9 SR7 (x64). The 2 parameter variante of subfield is not working (see attachted file)!

Any workarounds?

- Ralf

subfield 2 parameter problem on QV9 SR7

johnw — Thu, 28 Apr 2011 00:42:45 GMT

Yikes! Working in SR6, but that doesn't help you. Let's see, we want to create rows out of thin air. Crosstable can do that, but since it's all in one field, I don't see a way to take advantage of that. We can also create rows with a while loop, and it looks like we can solve it that way.

sub2:
LOAD subfield(F1,';',iterno()) as field2
RESIDENT test
WHILE len(subfield(F1,';',iterno()));

subfield 2 parameter problem on QV9 SR7

rbecher — Thu, 28 Apr 2011 08:31:29 GMT

Thanks John,

brilliant and very creative!

In the meantime I found out there is a new build 7778 (I had 7773) where the bug is fixed.

- Ralf

AW:Re: subfield 2 parameter problem on QV9 SR7

brenner_martina — Thu, 28 Apr 2011 09:31:37 GMT

Hi Ralf, Hi John,

in QV 10 SR2 it works fine!