Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Not applicable

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


It works.. Thank you Sushil,