topic Re: Merge two fields and sow as one dimension in Qlik Learning Discussions

Merge two fields and sow as one dimension

_rohitgharat — Fri, 20 Feb 2015 16:20:15 GMT

i have two fields for Eg. STATE and CITY. In pivot table i take two fields as dimension displaying in seerate column but i want to show it as single column only.

Location
State	city
maharashtra	mumbai

As seen in above table STATE and City are two fields of table and LOCATION is the column name i.e single column i have to show in pivot table i am suppose to display..

how to do this in qlikview ...Please do help..Your help would be apppreciated !!!!

Re: Merge two fields and sow as one dimension

Agis-Kalogiannis — Fri, 20 Feb 2015 22:25:44 GMT

You can create a calculated dimension for your Pivot Table as follows:

=State & ', ' & city

and name it Location in the label text field.

Thanks

Agis

Re: Merge two fields and sow as one dimension

mad — Fri, 20 Feb 2015 23:07:09 GMT

I would create this field in your load script:

State & ', ' & city as Location

It would be a new field that you can use and has less overhead then doing in the chart.

Re: Merge two fields and sow as one dimension

Sat, 21 Feb 2015 15:34:54 GMT

As the others have said the best way would be to concatenate the two fields in the script and give it a unique name

Re: Merge two fields and sow as one dimension

_rohitgharat — Fri, 27 Feb 2015 04:54:44 GMT

How to optimize data in qlikview???

Re: Merge two fields and sow as one dimension

Agis-Kalogiannis — Sun, 01 Mar 2015 13:45:58 GMT

Out of the two above answers, I must admit that Michael's answer is more efficient, provided that you have access and can modify the script.

In general, we prefer creating calculated field on the script rather than having to calculate them on the front end, which is a bit slower.

Re: Merge two fields and sow as one dimension

Anonymous — Sun, 01 Mar 2015 14:33:27 GMT

doing it in the script or in the application has a few implications,

let's say you want to add a list to filter specific combinations or states,

then you should concatenate it in the application, if not it is best to concatenate it in the script (performance wise)