Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Employee

Re: Selective Expression problem

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
Employee

Re: Selective Expression problem

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
Contributor III

Re: Selective Expression problem

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


or


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


The second is more effcient

Community Browser