topic Re: Please help explain this SubStringCount and Concat function expression :) in QlikView

Please help explain this SubStringCount and Concat function expression :)

jblomqvist — Thu, 06 Aug 2015 19:55:58 GMT

Hello

I have the following Dimensions and Expressions:

Measures:

LOAD * INLINE [

_MetricsNo, _Metrics

1, Sales

2, Margin

3, Margin %

4, Number of Orders

5, Average Discount

];

Dimensions:

LOAD * INLINE [

_Dimension

Re: Please help explain this SubStringCount and Concat function expression :)

Clever_Anjos — Thu, 06 Aug 2015 20:17:17 GMT

The '|' is there to avoid misinterpretation of substrings, for example

"Category1", "Category2" will not be considered since the concatenation would transform into "Category1|Category2"

>0 its a way of saying "More than one occurance"

Re: Please help explain this SubStringCount and Concat function expression :)

jblomqvist — Thu, 06 Aug 2015 20:19:53 GMT

Hi Clever,

Thanks for your reply Can you please elaborate a bit more on the two I almost understand but not fully.

You are saying without the '|' it would not work properly?

And what do you mean by more than one occurance?

Thanks

Re: Please help explain this SubStringCount and Concat function expression :)

Clever_Anjos — Thu, 06 Aug 2015 20:25:04 GMT

You are saying without the '|' it would not work properly?

In this application it will work, but using | is kind of a 'standard recipe', the person who elaborate the expression maybe saw this expression somewhere else

And what do you mean by more than one occurance?

If you have "Category" selected (or nothing is selected at all) , SubStringCount would return 1, if its not selected this will return 0.

Same remark about using a 'standard recipe'

Please add SubStringCount(Concat(_Dimension,'|'), 'Category') and Concat(_Dimension,'|') to textboxes and play with the listbox paying attention to the values returned

Re: Please help explain this SubStringCount and Concat function expression :)

Clever_Anjos — Thu, 06 Aug 2015 20:27:14 GMT

"Please add SubStringCount(Concat(_Dimension,'|'), 'Category') and Concat(_Dimension,'|') to textboxes and play with the listbox paying attention to the values returned"

Sorry, you already have done that