Joins condtions

[Anonymous]

Table1:

String	job type
23	coil tubiing1
24	Hint1
26	Hint2 Table2 String job type job type3 job type2 Sales 23 coil tubiing1 coil tubiing1 coil tubiing3 5000 24 Hint Hint1 Hint2 10000 26 Drilling Drilling2 Drilling3 20000

how to join  jobtype in such a way so that we can get all jobtype1,jobtype2,jobtype3 into one column

like

string  jobtype

23       Coli tubing1

23           Coil tubing2

23           Coil tubing3

l

in a way convert rows in columns and get only one sales value

[sunny_talwar]

May be you need this

The Crosstable Load

[Anonymous]

it will not work in bar chart

[sunny_talwar]

bar chart? Where did that come from? I have no idea what you mean

[Anonymous]

if we concatenate the way you said then we can use the column in x axis of bar chart in qlik sense visvulization

[Anonymous]

i mean convert

[Anonymous]

can you send qvf

[Anonymous]

in this case there are multiple dimension

String	job type	job type3	job type2	Sales
23	coil 25tubiing1	coil tubiing1	coil tubiing3	5000
24	Hint	Hint1	Hint2	10000
26	Drilling	Drilling2	Drilling3	20000

how will you transpose it

[Anonymous]

another example :

i want to use job type in x axis to get vlaues,

String

jobtype1

jobtype2

jobtype3

Value

1                coil1              coil2         coil3              40

After transpose

String	1
jobtype1	coil 1
jobtype2	coil2
jobtype3	coil 3
Value	40

and i can use job type as column

[Anonymous]

i can not use job type as column