Discussion board where members can get started with Qlik Sense.
I need your help.
My Data structure is as follows
id airline 100 9W101 9W|6E
102 9W|9W103 6E104 6E|6E|6E
where id is unique and auto-incremental. All airline codes are of 2 characters separated by a "|" character .
I have to find count of ids of each distinct airlineFinal output should be 9W: 4 (100,101,102,105)
6E : 3 (101, 103, 104) Every id is counted once even if it has multiple airlines.
Please guide, what functions/approach should I use.
Go to Solution.
I would create a linktable to get this done
LOAD * INLINE [
SubField(airline, '|') as airline_list
Subfiled should help in the script
subfield(airline, '|' ) as airlinecode
For each Airline Code you will have the ID, which you can count
Thanks a lot Sunny and Rupam. It Worked.Especially Sunny for attaching the qvf