topic how can I use wildsearch in dimension? in QlikView

how can I use wildsearch in dimension?

aytacbas — Sat, 04 Apr 2015 13:14:36 GMT

there are so many link on my dimension for example;

ref:

fbp_alb_3456

gad_1234

gad_8964

fb_lnk_7475

fb_lnk_6549

fbp_alb_8753

fbp_alb_2204

fbp_alb_1067

etc.

my expression is count(distinct(sales_id)) but I want to see dimension as:

ref (dimention) count(distinct(sales_id))

FBP_ALB, 4

FB_LNK, 2

GAD 2

sunny_talwar — Sat, 04 Apr 2015 13:22:22 GMT

Try this as your dimension:

=PurgeChar(Dim, '1234567890')

PFA

Best,

Sunny

sunny_talwar — Sat, 04 Apr 2015 13:30:48 GMT

To get the exact match of dimension, you can also use this:

=Upper(Left(PurgeChar(Dim, '1234567890'), Len(PurgeChar(Dim, '1234567890'))-1))

HTH

Best,

Sunny

vvvvvvizard — Sat, 04 Apr 2015 18:36:36 GMT

in dimension tab , click add calculated dimension , =left(ref,len(ref)-5)) , use this only if th ref always ends with - and 4 numbers