Help

[panipat1990]

Header 1
Policy No
P0016200004/9999/100017
P0016200004/9999/100018 P0016200004/9999/100002 P0016200004/1101/100031 P0016200004/4409/100001 P0016200004/3102/100008 P0016200004/9999/100009

Hi Team,

           My Requirement is

   I want to  All Policy No Which Has 9999... Take Out From Policy No.( Field) And Create A New Field.......

This Field Contain P0016200004/9999/100017........All Belongs To 9999........

[Clever_Anjos]

Usage Guidelines for Qlik Community

[cjohnson · Accepted solution]

Hi Gourav,

Can you let us know what you have tried so far to come up with an appropriate result so that you can be guided accordingly?

If I understand correctly you should be able to use the subfield function to get what you need.

Please see attached for more details.

Thanks,

Camile

[cjohnson]

I agree with this.

We want this community to be useful for everyone. It is not a platform for us to complete work for you - it is to share ideas. Usually in order post a question you want to provide an example with a specific problem, how you have tried to alleviate the problem and specific results that you are expecting..

I also took a look at some of your previous posts . It is helpful to the community - where if you receive helpful advice or the correct answer you mark it as such so that those discussions can be closed and other users can find the answers a lot more quickly.

cleveranjos‌ - How do you find a persons alias on here to be able to mention them? There are a number of gouravs on the forum and I wasn't sure where to go to find the correct one.

Thanks,

Camile

See here for more details:

Further thoughts on Qlik Community Guidelines

[Clever_Anjos]

cjohnson , I click on person link, and copy from URL

[MarcoWedel]

lots of help provided,

no replies to questions,

no green,

no "thank you"

[MarcoWedel]

Hi,

another solution could be:

tabYourSource:
LOAD *,
    RecNo() as %someKey,
    Ceil(Rand()*100) as someFact
Inline [
Policy No
P0016200004/9999/100017
P0016200004/9999/100018
P0016200004/9999/100002
P0016200004/1101/100031
P0016200004/4409/100001
P0016200004/3102/100008
P0016200004/9999/100009
];

tabPolicyFilter:
LOAD %someKey,
    [Policy No] as [Policy No without 9999]
Resident tabYourSource
Where not [Policy No] like '*/9999/*';

Concatenate(tabPolicyFilter)
LOAD %someKey,
    [Policy No] as [Policy No with 9999]
Resident tabYourSource
Where [Policy No] like '*/9999/*';

hope this helps

Maybe you could invest some of the time, the community invested in solving your issues, in reviewing and closing your threads.

thank you

regards

Marco

[Gysbert_Wassenaar]

Hi Gourav,

As others have pointed out you've received a lot of help from the community. We would very much like to see some feedback on that.

You often start your posts with "Hi Team,". Right now you're not behaving as a team member. If you want us to take you serious then you'll have to start acting like a team member.

If you don't know how to mark answers as helpful or as correct then let us know and we'll explain how to do that.

If you don't feel confident about your English, then stop worrying about it. You can try using google translate if you don't know how to ask your question in English.

Kind regards,

Gysbert