topic how substring(concat()) function works in adhoc reporting? in QlikView

how substring(concat()) function works in adhoc reporting?

omkarvamsi — Tue, 07 Jun 2016 14:53:00 GMT

Hi,

Could any one please explain how the functionalityof the below expression which i have used in adhoc reporting.

=SubStringCount(concat(Dimension_flag, '|'), 3)

I could not understand why pipe or vertical bar '|' is being used?

I know how substringcount() and concat() individually works but I couldn't get idea about Pipe symbol.

Even If i'm using this below expressions,my adhoc report is working.

SubStringCount(Mflag,1)

SubStringCount(Mflag,2)

Then why we are using '|'

Thanks In advance.!!

Re: how substring(concat()) function works in adhoc reporting?

sunny_talwar — Tue, 07 Jun 2016 15:28:53 GMT

The use of Pipe is to ensure that each value of Dimension_flag is separate from each other when you do a check. I would further change it to this may be

=SubStringCount(Concat('|' & Dimension_flag & '|', ','), '|3|')

Just to make sure that 3 can be differentiated from 13 because 13 also includes a 3.

Re: how substring(concat()) function works in adhoc reporting?

omkarvamsi — Wed, 08 Jun 2016 06:02:20 GMT

I understood.

Thank you Sunny