topic Re: join help in QlikView

join help

qvqfqlik — Wed, 29 Mar 2017 15:52:43 GMT

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.

Re: join help

Anonymous — Wed, 29 Mar 2017 16:00:46 GMT

Like this??

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

]

;

Re: join help

aarkay29 — Wed, 29 Mar 2017 16:34:47 GMT

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

];

Re: join help

qvqfqlik — Wed, 29 Mar 2017 17:23:42 GMT

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.

Re: join help

qvqfqlik — Wed, 29 Mar 2017 18:38:49 GMT

can you please help with this

Re: join help

qvqfqlik — Wed, 29 Mar 2017 19:09:23 GMT

can you please help with bar chart

Re: join help

aarkay29 — Wed, 29 Mar 2017 19:18:43 GMT

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

Re: join help

qvqfqlik — Wed, 29 Mar 2017 19:26:45 GMT

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

Re: join help

aarkay29 — Wed, 29 Mar 2017 19:45:04 GMT

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

Re: join help

qvqfqlik — Wed, 29 Mar 2017 20:05:00 GMT

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

Re: join help

aarkay29 — Wed, 29 Mar 2017 20:10:53 GMT

PFA

Re: join help

qvqfqlik — Wed, 29 Mar 2017 20:25:09 GMT

Thank you very much