Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:
String | job type | ||||||||||||||||||||
23 | coil tubiing1 | ||||||||||||||||||||
24 | Hint1 | ||||||||||||||||||||
26 | Hint2 Table2
|
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
May be you need this
it will not work in bar chart
bar chart? Where did that come from? I have no idea what you mean
if we concatenate the way you said then we can use the column in x axis of bar chart in qlik sense visvulization
i mean convert
can you send qvf
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
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
i can not use job type as column