topic Re: Two fields in one dimension in QlikView

Two fields in one dimension

Wed, 26 Jun 2013 06:15:35 GMT

Is there any code to combine two fields in one dimension? Example like object_operator and stuffs_operator displaying in one dimension.

FYI: I'm not refering to cyclic group

Wed, 26 Jun 2013 06:18:59 GMT

Depends on what kind of chart you are using. For instance, if you are using a pivot, you can add calculated dimension and combine the two fields

Wed, 26 Jun 2013 06:20:37 GMT

Pls check..

object_operator & stuffs_operator As [object_operator stuffs_operator],

Regards-Bika

narender123 — Wed, 26 Jun 2013 06:26:30 GMT

Hi ,

You can make it as composite kay in script.

Like:

load

object_operator,

stuffs_operator,

object_operator & '-' &stuffs_operator as Key

from Table abc;

Thanks,

Narender

er_mohit — Wed, 26 Jun 2013 06:33:37 GMT

Try this in dimension

object_operator & ' ' & stuffs_operator

hope it helps

Wed, 26 Jun 2013 06:39:50 GMT

Yes, i'm using pivot table. How to combine them?

Wed, 26 Jun 2013 07:05:01 GMT

add a calculated field as dimension wheren concatenate them using & operator. Checkout the sheet 1 in the attached Sales file.