topic Re: Making the table appear in the same column... in QlikView

Making the table appear in the same column...

Tue, 03 Sep 2013 12:28:50 GMT

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...

Re: Making the table appear in the same column...

Tue, 03 Sep 2013 12:32:43 GMT

Hi,

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.

-Jay

Re: Making the table appear in the same column...

Gysbert_Wassenaar — Tue, 03 Sep 2013 12:32:51 GMT

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

from ...mysource...

group by [Company Name];

Re: Making the table appear in the same column...

abeyphilip — Tue, 03 Sep 2013 12:38:10 GMT

Hi,

Are you using a table box?

Try using a straight table with company name as dimension and longitude and latitude as expressions.

Regards,

Abey

Re: Making the table appear in the same column...

Anonymous — Tue, 03 Sep 2013 17:03:34 GMT

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.

Regards,

Michael

Re: Making the table appear in the same column...

neetu_singh — Wed, 04 Sep 2013 10:54:30 GMT

Hi,

Please find the attached qvw, hope it will help you out

Regards

Neetu Singh