Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

How to track wild entries of field values which are comma separated , based on another comma separated field values ?

Hi All ,

How to tracking wild entries of field values which are comma separated , based on another comma separated field values ?

I know this will require subfield function , but i am not really sure about ways to get it done .

Input

    

AreaDatePersons_Present_on_Venue1Persons_who_made_to_Venue2Group
A112/12/2017Zena,Tom,KushalTomAlpha
A112/12/2017Tanisha,Bibo,Laura,SandyTanisha,BiboBeta
A214/12/2017AnushaBeta
A315/12/2017Sunny,Weber,NewtonFranklin,VaibhabAlpha
A417/12/2017Sunny,Weber,Newton,KrishSunny,NewtonAlpha

Note : Anusha is wild entry because it is not present in column Persons_Present_on_Venue1

          same goes for Franklin and Vaibhab

Output

     

AreaDateGroupNbr_of_People_at_V1Nbr_of_People_from_V1_Reached_V2Wild_Entry
A112/12/2017Alpha31
A112/12/2017Beta42
A214/12/2017Beta001
A315/12/2017Alpha302
A417/12/2017Alpha42

        

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
Highlighted

Re: How to track wild entries of field values which are comma separated , based on another comma separated field values ?

4 Replies
Highlighted

Re: How to track wild entries of field values which are comma separated , based on another comma separated field values ?

Hey look at that... I made it to venue1 and venue2

Highlighted

Re: How to track wild entries of field values which are comma separated , based on another comma separated field values ?

Highlighted
Specialist
Specialist

Re: How to track wild entries of field values which are comma separated , based on another comma separated field values ?

stalwar1‌ .. Sunny Bhai ... thoughts on above requirement ..

Highlighted
Specialist
Specialist

Re: How to track wild entries of field values which are comma separated , based on another comma separated field values ?

Sunny Bhai , how to find wild entries at script level ... in above case