topic Re: Problem in$ in dimension in QlikView

Problem in$ in dimension

Anonymous — Tue, 28 Feb 2017 11:01:08 GMT

My field Dim have the following value

if I apply the =$ it will give Error in calculation condition as output but if I use with it without $ will work fine

=$(=SubField(Concat(DISTINCT Dim, '|'), '|', 1))

Error :Garbage after expression :"Affected"

If I use this ,it will Business affected 1 as Output

=SubField(Concat(DISTINCT Dim, '|'), '|',2 )

sunny_talwar — Tue, 28 Feb 2017 11:05:58 GMT

Try this:

=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')

Anonymous — Tue, 28 Feb 2017 11:12:42 GMT

Cool..

Thanks