topic Re: How to select in a table or pivot table only in QlikView

How to select in a table or pivot table only

stephane_kosior — Tue, 26 Sep 2017 10:27:16 GMT

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

Re: How to select in a table or pivot table only

Anil_Babu_Samineni — Tue, 26 Sep 2017 10:30:45 GMT

You can try 2 ways

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

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

Re: How to select in a table or pivot table only

stephane_kosior — Tue, 26 Sep 2017 12:29:51 GMT

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 ...

Re: How to select in a table or pivot table only

stephane_kosior — Tue, 26 Sep 2017 13:12:28 GMT

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