topic Re: Pass a variable a text to substring count in QlikView

Pass a variable a text to substring count

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

How do I pass a variable as text to substring count?

Thanks

=SubStringCount($([Curent Spreadsheet]),'\')

oscar_ortiz — Wed, 06 Jul 2016 08:54:01 GMT

Simply wrap the dollar sign expansion in single quotes.

'$(yourvariable)'

tinkerz1 — Wed, 06 Jul 2016 10:22:44 GMT

Thanks, however when continute to expand the formula to

=index('$(Current Spreadsheet)',SubStringCount('$(Current Spreadsheet)','\'))

It returns zero, why wont index pick up the number?

The next stage is to wrap the above formula inside left('$(Current Spreadsheet)',above formula)

Thanks

marcus_sommer — Wed, 06 Jul 2016 10:49:35 GMT

Your expression searched within a string (your variable) the number of backslashes within them, like:

index('string', 3)

is it what do you want to do?

- Marcus

oscar_ortiz — Wed, 06 Jul 2016 17:24:21 GMT

What is the actual value of your variable? Also, I don't believe variables can have spaces.