Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two table
Table A
Date Process1 Process2 Process3
01/01/2016 C C C
02/01/2016 C C C
03/01/2016 C C C
Table B
Date Source Event
01/01/2016 Process1 login error
01/01/2016 Process1 Success
02/01/2016 Process2 error
02/01/2016 Process3 error
When I just load the tables qlikview links the date and I get want to be able to select one date and see the process1 value from Table A and Events from Table B for the same date .
I created two strait tables for each table in the dashboard but it shows – in the straight table when I select the date. Why is the second table not displaying the events from the same date?
Can someone help?
Hi,
Please find the attached file,
I hope this is helpful for you.
T1:
load * Inline [
Date , Process1, Process2 , Process3
01/01/2016 , C , C , C
02/01/2016 , C , C , C
03/01/2016 , C , C , C
];
T2:
LOAD *,RecNo() as Rec;
LOAD * Inline [
Date , Source , Event
01/01/2016 , Process1 , login error
01/01/2016 , Process1 , Success
02/01/2016 , Process2 , error
02/01/2016 , Process3 , error
];
Regards,
Mahesh
Hi,
Please find the attached file,
I hope this is helpful for you.
T1:
load * Inline [
Date , Process1, Process2 , Process3
01/01/2016 , C , C , C
02/01/2016 , C , C , C
03/01/2016 , C , C , C
];
T2:
LOAD *,RecNo() as Rec;
LOAD * Inline [
Date , Source , Event
01/01/2016 , Process1 , login error
01/01/2016 , Process1 , Success
02/01/2016 , Process2 , error
02/01/2016 , Process3 , error
];
Regards,
Mahesh
Could be any issue with your datefield from either of the two tables. Look here:
Hi Mahesh,
when I try to load my original tables with the link field as date
And load the date field to the List box, I am getting duplicates of Dates in the list box.
My Table A has values for 2 dates , my table b has values for 5 dates in which 3 are common date .
Ideally i should get only unique dates in list box right .
any idea why the dates get repeated in the List box ?
The duplicate is due to the date format issues
Date(floor([DateToProcess]), 'MM/DD/YYYY') works to remove the duplicates .
thanks Mahesh