Discussion board where members can get started with QlikView.
I have a table
I want to see in the data model
only common codes in all the countries.
my output should be like this
how do we accomplish this ??
LOAD * INLINE [
Left Join (temp)
count(DISTINCT country) as Count
Group By code;
Right Join (temp)
LOAD Max(Count) as Count
NoConcatenate LOAD code,
Concat(country,',') as TotalCountries,
Len(Concat(country,',')) as TotalCountriesLength
FirstSortedValue(Distinct TotalCountries,-TotalCountriesLength) As TotalCountries
SubField(TotalCountries,',') As Country,
Drop Table T1;
Thank you Sunny for your response.
Also can you look @ the below issue.?
Suggest me where I did wrong completely I got stucked to figure out.
Can you help me out from this???