Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

sagarrahul
New Contributor III

sequence

hii frnds

need a small help from you

i have this five digit below

12345

when this five digit comes in any policy_num it should show all the value which are having this digits

whether this ie 12345 comes before or after or in between in policy_num(but in same sequences as 12345)

KC19E800212345
HA10ENEGC012345
391234512CVB7
12345E0097896
14 Replies
surendraj
Valued Contributor

Re: sequence

Try this,

LOAD * INLINE [

    Policy_num

    KC19E800212345

    HA10ENEGC012345

    391234512CVB7

    12345E0097896

    345E0097857878

  

]Where WildMatch(Policy_num, '*12345*');

it will show first 4 values only.5th value doesn't have 12345 sequence.

result:

1.png

sagarrahul
New Contributor III

Re: sequence

i want this in script form not in load form

surendraj
Valued Contributor

Re: sequence

I wrote/tried it in script only..

I just take a sample data to test your requirement.

You can use it

WildMatch(Policy_num, '*12345*'

345E0097857878 for this value there is no sequence as 12345.

so it ristiricts the above value in listbox.

sagarrahul
New Contributor III

Re: sequence

ty wil try it

surendraj
Valued Contributor

Re: sequence

Hi Sagar,

Didn't you got the solution what you r looking for?

sagarrahul
New Contributor III

Re: sequence

thanks it work

surendraj
Valued Contributor

Re: sequence

Ok Sagar, thats gud..

Then please close the thread...It will help to community members..

sagarrahul
New Contributor III

Re: sequence

how to close

surendraj
Valued Contributor

Re: sequence

Mark that correct answer to  one of your responses which you got the relevant solution..

Community Browser