topic Re: please help? in QlikView

please help?

Mon, 05 May 2014 04:42:37 GMT

please help?

Re: please help?

Mon, 05 May 2014 04:44:11 GMT

hi ,

i want to add field of two diifferent list boxes in to one list box and want to use it as a dimension

Could you please help ?

Re: please help?

tresB — Mon, 05 May 2014 04:48:54 GMT

It depends on data model (how the fields are associated). Try to share your sample qvw.

Re: please help?

Mon, 05 May 2014 04:54:52 GMT

both list boxes are having similiar type of fields but one list box is having data of mech dep and another one is having data of electrical dep.

so basically i want to show revenue of two dep on A SINGLE GRAPH . THE FIELD I WANT TO COMBINE IS Department SO DAT MY GRAPH DIMENSION WILL SHOW electrical and mechanical sep.

Re: please help?

tresB — Mon, 05 May 2014 04:59:31 GMT

Again, it's hard to answer without knowing your model. Theoritically can be told that, you could think of CONCATENATEing the table.

Re: please help?

Mon, 05 May 2014 05:01:31 GMT

Hi,

If the fields are associated,you can use expression in List Box instead of Field Name. (eg: =Field1 &'-'& Field2).

Re: please help?

its_anandrjs — Mon, 05 May 2014 05:36:19 GMT

If your data model is perfect then in the dimension you can use

=Field1&'_'&Field2 same you can use in any list box try to plot any list box and in expression write two fields with concate words like &'_'&