Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thank you Oleg,
That worked.
Cheers.