How to select in a table or pivot table only

[stephane_kosior]

Hi

I have a pivot table coming from the result of 2 tables (tblinvoices (SQL) ; tblActions (xls)). I would like to show only the invoices where there is no action ?

Could you please let me know how this can be done either in the script, either in the pivot table ?

Many thanks

[Anil_Babu_Samineni]

You can try 2 ways

1) Script - Load * from Table Where invoices like 'no action';

2) UI - Sum({<invoices = {'no action'}>} Measure)

[stephane_kosior]

Many thanks Anil  but it's not simple as it is ... I haven't got the information that there is no action. QV tries to link the two table and show that sometimes there are some actions, sometimes QV shows '-' as QV cannot find the information from the table tblActions.

Or I missunderstood your answer ...

[stephane_kosior]

In other words, what are the invoices from tblinvoices NOT IN tblActions ...