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: 
Anonymous
Not applicable

Getting rows with - in straight table

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?

1 Solution

Accepted Solutions
qlikview979
Specialist
Specialist

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

Untitled.png

View solution in original post

4 Replies
qlikview979
Specialist
Specialist

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

Untitled.png

sunny_talwar

Could be any issue with your datefield from either of the two tables. Look here:

Get the Dates Right

Why don’t my dates work?

Anonymous
Not applicable
Author

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 ?

Anonymous
Not applicable
Author

The duplicate is due to the date format issues

  Date(floor([DateToProcess]), 'MM/DD/YYYY') works to remove the duplicates .

thanks Mahesh