topic Re: Help in QlikView

Help

panipat1990 — Tue, 06 Oct 2015 18:11:37 GMT

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........

Re: Help

Clever_Anjos — Tue, 06 Oct 2015 18:14:50 GMT

Usage Guidelines for Qlik Community

Re: Help

cjohnson — Tue, 06 Oct 2015 18:18:38 GMT

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

Re: Help

cjohnson — Tue, 06 Oct 2015 18:31:13 GMT

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

Re: Help

Clever_Anjos — Tue, 06 Oct 2015 20:05:55 GMT

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

Re: Help

MarcoWedel — Tue, 06 Oct 2015 21:31:15 GMT

lots of help provided,

no replies to questions,

no green,

no "thank you"

Re: Help

MarcoWedel — Tue, 06 Oct 2015 21:51:00 GMT

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

Re: Help

Gysbert_Wassenaar — Wed, 07 Oct 2015 05:32:05 GMT

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