Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shabarish0587
Contributor III
Contributor III

How to count IDs by Multiple Language

Hello Everyone,

                         I have a columns like MKT, Language and ID columns, i want to show the data in Pivot Table like where we have two languages in language columns we need to calculate count of ID for the multiple language row. I am attaching sample excel file here.

shabarish0587_0-1721546407624.png

               Can any one help me on this.Thanks in Advance.

 

Labels (3)
1 Solution

Accepted Solutions
anat
Master
Master

T:
load * Where Len(trim(cnt))>0;
LOAD *,SubField(Language,';',2) as cnt
;
load * Inline [
MKT Language ID
IN-MKT English; 121
IN-MKT English;Hindi 122
IN-MKT Hindi; 122
JP-MKT English 123
JP-MKT English;Japan 123
JP-MKT Japan;English 124
JP-MKT English;Japan 125
US-MKT English;Spanish 126
US-MKT English; 126
UK-MKT English; 127
UK-MKT English;German 128
UK-MKT English;Spanish;German 129

](delimiter is ' ')

anat_0-1721580135441.png

 

View solution in original post

2 Replies
anat
Master
Master

T:
load * Where Len(trim(cnt))>0;
LOAD *,SubField(Language,';',2) as cnt
;
load * Inline [
MKT Language ID
IN-MKT English; 121
IN-MKT English;Hindi 122
IN-MKT Hindi; 122
JP-MKT English 123
JP-MKT English;Japan 123
JP-MKT Japan;English 124
JP-MKT English;Japan 125
US-MKT English;Spanish 126
US-MKT English; 126
UK-MKT English; 127
UK-MKT English;German 128
UK-MKT English;Spanish;German 129

](delimiter is ' ')

anat_0-1721580135441.png

 

shabarish0587
Contributor III
Contributor III
Author

Thank you Anant