Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

View solution in original post

yduval75
Partner
Partner

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


or


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


The second is more effcient