topic Re: Explanation? in QlikView

Explanation?

Anonymous — Tue, 16 Sep 2014 09:25:07 GMT

Hi..

Can you please give a explanation about following expression.

=SubStringCount('|' & Concat(distinct %ExpressionName, '|') & '|', '|Total Sales|')

MK_QSL — Tue, 16 Sep 2014 09:29:50 GMT

Similar to this.... except the Concat and Search String are having '|' at the start and end...

anbu1984 — Tue, 16 Sep 2014 09:31:45 GMT

Concat(distinct %ExpressionName, '|') - Returns distinct aggregated ExpressionName

Anonymous — Tue, 16 Sep 2014 09:43:02 GMT

Hi anbu..

Thank you for your reply....

In Concat(distinct %ExpressionName, '|')

Distinct %ExpressionName returns distinct values of %ExpressionName.

But I can't understood about '|' and Concat(distinct %ExpressionName, '|').

Can you please explain in detail.....

Thanks & Regards,

chandini.G

anbu1984 — Tue, 16 Sep 2014 09:52:39 GMT

Concat(distinct %ExpressionName, '|')

If %ExpressionName has only one value say 'Total Sales',

Concat(distinct %ExpressionName, '|') returns 'Total Sales' without Pipe

If %ExpressionName has three values say 'Total amount', 'Total Sales' , 'Total value'

Concat(distinct %ExpressionName, '|') returns Total amount|Total Sales|Total value

So '|' beginning and end of Concat, so we can use '|Total Sales|' to get substring count.

Anonymous — Tue, 16 Sep 2014 09:58:45 GMT

Hi Anbu..

Thanks for your reply...

Its Helpfull for me...........

Thanks & Regards,

Chandini.G