Discussion Board for collaboration on QlikView Scripting.
there are so many link on my dimension for example;
my expression is count(distinct(sales_id)) but I want to see dimension as:
ref (dimention) count(distinct(sales_id))
Try this as your dimension:
To get the exact match of dimension, you can also use this:
=Upper(Left(PurgeChar(Dim, '1234567890'), Len(PurgeChar(Dim, '1234567890'))-1))
in dimension tab , click add calculated dimension , =left(ref,len(ref)-5)) , use this only if th ref always ends with - and 4 numbers