topic Re: SubStringCount(Concat Question in QlikView

SubStringCount(Concat Question

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have a problem with my SubStringCount(Concat conditional option in my table.

Right now im using:

LOAD * INLINE [dimension_1,dimension_flag

Month,1

Date, 2

Etc.

And

LOAD * INLINE [Parameter_1, Parameter_flag

Budget, A

Tax, B

Etc.

In my script to determine what dimensions and expressions I want to show/hide in my table.

The problem i'm running into is that whenever I use 10 as a dimension_flag: 10, 1, and 0 get selected in my table. Is there any way how I can add more than 10 dimensions without causing this problem?

Thanks in advance.

Re: SubStringCount(Concat Question

Oleg_Troyansky — Wed, 16 Sep 2015 17:52:26 GMT

You can do a few things here:

- replace numbers with letters, and you will be able to add many more dimensions.

- or, used 2-digit numbers:

instead of 1 or 2, search for '01', '02', etc...

this way. you can have up to 99 dimensions.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: SubStringCount(Concat Question

Thu, 17 Sep 2015 06:34:41 GMT

Thank you Oleg,

That worked.

Cheers.