Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead 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
JonnyPoole
Employee
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

View solution in original post

2 Replies
JonnyPoole
Employee
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

yduval75
Partner
Partner

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


or


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


The second is more effcient