Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
MVP & Luminary
MVP & Luminary

subfield 2 parameter problem on QV9 SR7

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

Vizlib Head of R&D
3 Replies
Highlighted
MVP
MVP

subfield 2 parameter problem on QV9 SR7

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()));

Highlighted
MVP & Luminary
MVP & Luminary

subfield 2 parameter problem on QV9 SR7

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

Vizlib Head of R&D
Highlighted
Partner
Partner

AW:Re: subfield 2 parameter problem on QV9 SR7

Hi Ralf, Hi John,

in QV 10 SR2 it works fine!