Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

rohit18492
New Contributor III

Merge two fields and sow as one dimension

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
Statecity
maharashtramumbai

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

6 Replies
Employee
Employee

Re: Merge two fields and sow as one dimension

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

mad
New Contributor

Re: Merge two fields and sow as one dimension

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.

Not applicable

Re: Merge two fields and sow as one dimension

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

rohit18492
New Contributor III

Re: Merge two fields and sow as one dimension

How to optimize data in qlikview???

Employee
Employee

Re: Merge two fields and sow as one dimension

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.

nirkatz123
New Contributor II

Re: Merge two fields and sow as one dimension

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)

Community Browser