topic Re: Getting rows with - in straight table in QlikView

Getting rows with - in straight table

Anonymous — Mon, 30 May 2016 07:14:09 GMT

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?

Re: Getting rows with - in straight table

qlikview979 — Mon, 30 May 2016 09:54:11 GMT

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

Re: Getting rows with - in straight table

sunny_talwar — Mon, 30 May 2016 11:28:53 GMT

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?

Re: Getting rows with - in straight table

Anonymous — Mon, 30 May 2016 12:32:13 GMT

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 ?

Re: Getting rows with - in straight table

Anonymous — Mon, 30 May 2016 12:47:42 GMT

The duplicate is due to the date format issues

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

thanks Mahesh