# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Selective Expression problem

The standard procedure of implementing selective expressions in a pivot table presents a problem beyond 9 lines in the metrics table. the SubStringCount(Concat(%metric, '|'), 10) method evaluates true for line 1 as well and both expressions are selected.

Is there a way to solve this?

1 Solution

Accepted Solutions
Employee

If you want to support up to 999 , use 001, 002,003 ... 999

If you want to support up to 9999 , use  0001,0002,0003,0004  ....9999

The difference is the leading zeros. Don't use 1,2,3...

ps: don't put 9999 columns in a table

2 Replies
Employee

If you want to support up to 999 , use 001, 002,003 ... 999

If you want to support up to 9999 , use  0001,0002,0003,0004  ....9999

The difference is the leading zeros. Don't use 1,2,3...

ps: don't put 9999 columns in a table

Partner

=count({\$ * <[%metric]={10}>} [%metric]) = 1

or

count({<[_%metric]*={10}>} [%metric]) = 1

The second is more effcient