Discussion Board for collaboration on QlikView Scripting.
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:MMS') as key,
BT_TRAK_NO&'_'&BT_LINE_NO&'_'&BT_RXCNC_FLAG&'_'&BT_RXCNC_MACHINE&'_'&Date(BT_RXCNC_DATETIME,'MM/DD/YYYY HH:MMS') 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:
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.
Go to Solution.
In chart>Dimension> check suppress when value is null.
It works.. Thank you Sushil,