topic SubStringCount(Concat in QlikView

SubStringCount(Concat

carolin01 — Fri, 07 Mar 2014 12:12:04 GMT

Hello together,

I´m trying to show some expressions in my chart only conditionally. Therefore I created in my script a table that I use in a list box:

LOAD * INLINE [_DisplayChartReference, _references
    1, Plan,
    2, YTD,
    3, Outlook,
];

Now my expression in my chart has the following condition:

SubStringCount(Concat(_DisplayChartReference, '|'), 1)

I also tried:

SubStringCount(Concat(_references, '|'), 'Plan')>1,1,0)

But both doesn´t work. I already created a self report with a pivot table. Here this worked well and therefore I don´t understand what I´m doing wrong?

Many thanks for your help 🙂

Best regards,

Carolin

Re: SubStringCount(Concat

Gysbert_Wassenaar — Fri, 07 Mar 2014 12:18:39 GMT

Perhaps: SubStringCount(Concat(_DisplayChartReference, '|'), '1')

The second won't work without an if:

=if(SubStringCount(Concat(_references, '|'), 'Plan')>1,1,0)

Re: SubStringCount(Concat

sunilkumarqv — Fri, 07 Mar 2014 12:30:57 GMT

try this

In the dimension properties, check the option for “Enable Conditional” and enter the following code

You will want to add similar code to each dimension, changing the letter to correspond with what you used in your inline table.

=SubStringCount(Concat(_references, '|'), 'Plan')

The last thing to do is add a Calculation Condition to the general tab of the object so that the object only displays when at least one dimension and expression is selected:

GetSelectedCount(_DisplayChartReference)>0 AND GetSelectedCount(_Expression)>0

Re: SubStringCount(Concat

simondachstr — Fri, 07 Mar 2014 12:39:53 GMT

This document I wrote on substringcount could be useful for your implementation:

http://community.qlik.com/docs/DOC-5841

Re: SubStringCount(Concat

carolin01 — Fri, 07 Mar 2014 12:40:45 GMT

Thank you both, both worked well. Maybe you could help me with another question:

My list box has got three values that I will connect to the expressions:

Plan, YTD and Outlook

Right now, if nothing is selected then all three expression appear. I would like to have the oposite: Only if Plan, YTD or Outlook is selected the expression should appear. Is this possible?

Re: SubStringCount(Concat

Gysbert_Wassenaar — Fri, 07 Mar 2014 12:52:23 GMT

Sunil already posted the answer to that in his last post. You can use the getselectedcount function for that.

Re: SubStringCount(Concat

carolin01 — Fri, 07 Mar 2014 13:06:27 GMT

Sorry right, I see. Thank you