Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please help?

please help?

6 Replies
Not applicable
Author

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 ?

tresesco
MVP
MVP

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

Not applicable
Author

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.

tresesco
MVP
MVP

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

Not applicable
Author

Hi,

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

concate.png

its_anandrjs
Champion III
Champion III

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 &'_'&