This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
guys, how do I fix this?
I want to be a table like "Company Name"|"Longitude"|"Latitude"|, appearing both at the same company name, not making it 3 times...
please see the Attached file...
I assume the data was created by conctenating Latitude and, separately, Longitude to the Company Name. If you join instead of concatenate, it should be fine.
View solution in original post
If all the three fields available in same table ,then you concatenate of all the three fields together like below
Company Name&'-'&Longitude&'-'&Latitude as Company_Details.
You can use a straight table instead of a table box and use Company Name as dimension and two expressions max(Longitude) and max(Latitude).
If you want to fix this in the script it would help if you could show us what the source data looks like. Perhaps using the max function can help there too:
Load [Company Name], firstvalue(Longitude) as Longitude, firstvalue(Latitude) as Latitudde
group by [Company Name];
Are you using a table box?
Try using a straight table with company name as dimension and longitude and latitude as expressions.
Please find the attached qvw, hope it will help you out