Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Unexpected data in loading data from 2 tables using Key

Hello Team,

I am loading data from 2 tables using a key (combination of 5 fields) in load statement.

   TRCK_TRAK_NO &'_'&TRCK_LINE_NO&'_'&TRCK_JOB_FLAG&'_'&TRCK_MACHINE&'_'&Date(TRCK_DATETIME ,'MM/DD/YYYY HH:MMSmiley FrustratedS') as key,

BT_TRAK_NO&'_'&BT_LINE_NO&'_'&BT_RXCNC_FLAG&'_'&BT_RXCNC_MACHINE&'_'&Date(BT_RXCNC_DATETIME,'MM/DD/YYYY HH:MMSmiley FrustratedS') as key

in which one table is a subset of other.

when i display the entire data in Table chart I am seeing data as below:

2014-08-25_121524.png

Table View:

2014-08-25_121920.png

When I select any of the parameters, it is perfect. but when i do 'Clear Selection', I don't want to see the marked above section.

Please help me in getting rid of this.

Thanks,

Deepa

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Unexpected data in loading data from 2 tables using Key

In chart>Dimension> check suppress when value is null.

2 Replies
sushil353
Honored Contributor II

Re: Unexpected data in loading data from 2 tables using Key

In chart>Dimension> check suppress when value is null.

Highlighted
Not applicable

Re: Unexpected data in loading data from 2 tables using Key


It works.. Thank you Sushil,

Community Browser