topic Re: Selective Expression problem in QlikView

Selective Expression problem

Wed, 03 Dec 2014 14:04:26 GMT

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?

Re: Selective Expression problem

JonnyPoole — Wed, 03 Dec 2014 14:08:29 GMT

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

Re: Selective Expression problem

yduval75 — Wed, 03 Dec 2014 14:12:31 GMT

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

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

The second is more effcient