topic Re: check for certain value in field in QlikView

check for certain value in field

markgraham123 — Tue, 08 Nov 2016 15:41:01 GMT

Hi all,

I'm trying to create a flag if ID has 0102 or 0607 in its name. Can someone please help?

ID, Name

1, 0102,0304,0102, 0909

2, 0102,0607

Re: check for certain value in field

julian_rodriguez — Tue, 08 Nov 2016 15:44:35 GMT

Hello Mark

On the load script

LOAD

If(Index(Name,'0102')>0 Or Index(Name,'0607')>0, 1,0) As FlagId,

.....;

Then you can select all the rows that has 1 as FlagId

Regards

Re: check for certain value in field

sunny_talwar — Tue, 08 Nov 2016 15:44:48 GMT

May be like this:

LOAD ID,

Name,

If(SubStringCount(ID, '0102') >= 1 or SubStringCount(ID, '0607') >= 1, 1, 0) as Flag

FROM...

Re: check for certain value in field

Anonymous — Tue, 08 Nov 2016 15:45:48 GMT

in a Chart create e.g calculated Dimension like

=if (match(Name,'0102','ß607') > 0, Name, null()) and suppress Zero values

in script you may load

load ID,

Name

from ...

where match(Name,'0102','0607') > 0;

Re: check for certain value in field

maxgro — Tue, 08 Nov 2016 15:47:49 GMT

maybe

WildMatch(Name, '*0102*', '*0607*')

Re: check for certain value in field

markgraham123 — Tue, 08 Nov 2016 15:49:52 GMT

Sunny,

What if i have my date set :

ID, Name

1, 0102,0304,0102, 0909

1, 0102,5594

2, 0102,0607

2, 0102,0609

Re: check for certain value in field

sunny_talwar — Tue, 08 Nov 2016 15:55:04 GMT

It should still work, I think

Re: check for certain value in field

markgraham123 — Tue, 08 Nov 2016 16:01:29 GMT

Thanks

Re: check for certain value in field

markgraham123 — Tue, 08 Nov 2016 16:04:13 GMT

Sunny,

What if i have 100 s of names and i want create a loop to dynamically check and assign flag in back end for every name existence??

Re: check for certain value in field

markgraham123 — Tue, 08 Nov 2016 16:05:22 GMT

i have names from 0101 to 0990 (May be group by name or something)

If any ID has name 0101 then i want to give flag 'Y' for 0101

same till 0990

Re: check for certain value in field

julian_rodriguez — Tue, 08 Nov 2016 16:07:51 GMT

Hello Mark

Please see the MapSubstring function, pherhaps can be useful for your need

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/MapSubstring.htm

Regards