select those customer id who not available in transaction table

[Anonymous]

hi guys,

can you help me out to pick those customer who not available in transaction table. select dynamic customer according to click on date.

regards,

faizan

[Gysbert_Wassenaar]

See attached qvw

[Anonymous]

thanks for the solution but i don't need to diplay a expession value  i show the emp only in list box who don't have any transaction in a particular date

[nirav_bhimani]

Hi Try this Expression in Dimnesion of EmpId Listbox

=if (isnull(t_date),emp_id)

OR in the script

if (isnull(t_date),1,0) as Flag

then, Try this in Expression

Only({<Flag={1}>}emp_id)

Regards,

Nirav Bhimani

[Anonymous]

i already try that but if you hide the expression the emp id is not showing

[Anonymous]

thanks guys its work properly.