Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

join help

Iam trying to join and get data in such a way that

when there is a match for a number from table1 in table2 , I would need to display the fname and lname from table1

and when there is no match for a number, I simply need to show the number from table2

I have attached some sample data.

Please help me with this.

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

I hope this is what you want, let me know if this does not work for you

View solution in original post

11 Replies
Anonymous
Not applicable

Like this??

Capture.PNG

tab1:

load * inline

[number,fname,Lname

4321,rob,dan

6879,svet,shan

7432,kina,jone

2134,anna,aime

];

join

tab2:

Load * inline

[

number,minutes

12345,10

5678,20

7890,30

4321,5

6879,8

]

;

aarkay29
Specialist
Specialist

May be this

if you want to avoid customer numbers in table2 containing fname and lname have no match from table 1 and table 2

Table:

Load * Inline [

number,minutes

12345,10

5678,20

7890,30

4321,5

6879,8

];

Left Join(Table)

Load * Inline [

number,fname,Lname

4321,rob,dan

6879,svet,shan

7432,kina,jone

2134,anna,aime

];

qvqfqlik
Creator
Creator
Author

I am trying to create a bar chart

for a certain date

on x-axis I will have to show customer name from table1, if there is a match for number

else , if there is no match for a number, I will have to show only the number from table2.

on y-axis I need to show by timeperiod  and dollars. I have attached spreadsheet to my post.

please help with this.

qvqfqlik
Creator
Creator
Author

can you please help with this

qvqfqlik
Creator
Creator
Author

can you please help with bar chart

aarkay29
Specialist
Specialist

Can you post sample output that you are looking for? Please!!!

qvqfqlik
Creator
Creator
Author

I attached the file that I was trying to work on. bar chart or combo chart

for a given date , on the x-axis, I need to show name of the person (name from tab1 ...if there is a number match in both the tables).

If there is no number match, I need to show the number itself (from tab2)on the x-axis

on y-axis I need to show count of timeperiod or bill amount

I was wondering what all I need to add in the group and expression.

please help

aarkay29
Specialist
Specialist

I hope this is what you want, let me know if this does not work for you

qvqfqlik
Creator
Creator
Author

this works amazing

but like yours, how to get denominations of 0,2,...12 on left side of y-axis and 0,50,..100 on right side of y-axis ?

and bars look tiny

d1.JPG