Discussion board where members can get started with QlikView.
I have an basic question.
I have text object with value as "ABCD%EFG%"
How can I go about finding the position of % and display in another text object?
=Concat(If(Index('ABCD%EFG%', '%', ValueLoop(1, 100)) > 0, Index('ABCD%EFG%', '%', ValueLoop(1, 100))), ', ')
View solution in original post
The first occurrence displays as 5 but it is not bringing the second occurrence.
I used this expression and it returns 8. But I need the position 4 also.
How can I do that?
Wow. That's an awesome advanced expression and it works.
Thanks much Sunny!