topic Re: Joins condtions in Integration, Extension & APIs

Joins condtions

Anonymous — Fri, 22 Dec 2017 10:31:09 GMT

Table1:

String

job type

coil tubiing1

Hint1

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

string jobtype

23 Coli tubing1

23 Coil tubing2

23 Coil tubing3

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

Re: Joins condtions

sunny_talwar — Fri, 22 Dec 2017 12:18:27 GMT

May be you need this

The Crosstable Load

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 14:44:19 GMT

it will not work in bar chart

Re: Joins condtions

sunny_talwar — Fri, 22 Dec 2017 14:45:51 GMT

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

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 14:56:13 GMT

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

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 14:58:56 GMT

i mean convert

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 15:05:13 GMT

can you send qvf

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 15:12:26 GMT

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

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 15:35:33 GMT

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

Re: Joins condtions

Anonymous — Fri, 22 Dec 2017 15:35:57 GMT

i can not use job type as column