topic Re: show if value is present in string in QlikView

show if value is present in string

pepe2209 — Fri, 05 Dec 2014 14:18:24 GMT

Hello

i have the following table

Client	Charts
A	1,2,3
B	1,2
C	1,3

The string within the charts-field refers to the charts that should be visible per client.

So for chart one i want to have a conditional show if the value 1 is present in the string.

chart two for value 2

chart three for value 3 etc.

what is the most effective way to identify if a value is part of a larger string?

your help would be much appreciated.

Kind regards,

Peter

Re: show if value is present in string

Fri, 05 Dec 2014 14:22:04 GMT

Hi Peter,

Index should do the job for you

Index([Your string here],'1')>0 for instance

hope that helps

Joe

Re: show if value is present in string

Anonymous — Fri, 05 Dec 2014 14:22:40 GMT

if ( index ([Charts] , '2' ) > 0 , .......................

Re: show if value is present in string

Fri, 05 Dec 2014 14:23:03 GMT

Hi Pete

U can use Match(), Mixmatch() or WildMatch() depending on the way u wanna search your string. All 3 can be found I the help menu.

/ Teis

Re: show if value is present in string

pepe2209 — Fri, 05 Dec 2014 14:29:36 GMT

Thanks but it is not the complete solution.

Because the string can go up to 11,12, etc. So with the following string: 3,8,11 it will still identify '1' in '11'.

Re: show if value is present in string

Fri, 05 Dec 2014 14:32:47 GMT

Just add in your delimiter to ensure the proper match?

Index([Your string here]&',','1,')>0

Index([Your string here]&',','11,')>0

Edit: need to add the comma at the end to make sure last one is picked up

Re: show if value is present in string

pepe2209 — Fri, 05 Dec 2014 14:41:33 GMT

thanks Joe!

I only needed a comma at the start to or else it will still identify '1,' in '11,'

so now it is:

Index(','&[Your string here]&',', ',1,')

Index(','&[Your string here]&',', ',11,')

Re: show if value is present in string

Anonymous — Fri, 05 Dec 2014 14:42:16 GMT

Try 1s and 0s.

A 111

B 110

C 101

And then use string functions like mid() to determine.

Serhan

Re: show if value is present in string

Fri, 05 Dec 2014 14:46:17 GMT

good point sorry yea forgot that one!