topic Re: check missing values in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:34:04 GMT

Re: check missing values

ahaahaaha — Tue, 09 May 2017 08:36:59 GMT

Hi Agrim,

As variant, you can use Set Analisys expression to work similarly to the island of data. In attached file I gave an example of selecting only the same records in fields [Assetname] and [Item] (Table 3) and the same records selection with the state of field Statename as 'Non-active' (Table 4).

Similar to this approach, you can make the other selections you need.

Regards,

Andrey

Re: check missing values

vinieme12 — Tue, 09 May 2017 08:59:18 GMT

this

map_report:

Mapping LOAD upper(Assetname) as Assetname,

'Exists in Report'

FROM

(biff, embedded labels, table is report$);

map_Feuil1:

Mapping LOAD

upper(Item) as ITEM,

'Exists in Feuil1'

FROM

(biff, embedded labels, table is Feuil1$);

Tab_Feuil1:

LOAD Catégorie,

Item,

[Date d'installation],

ApplyMap('map_report',upper(Item),'Not Exist in Report') as ReportExistsFlag

FROM

(biff, embedded labels, table is Feuil1$);

LOAD Assetname,

Statename,

Lastchanged,

ApplyMap('map_Feuil1',upper(Assetname),'Not Exist in Feuil1') as Feuil1ExistsFlag

FROM

(biff, embedded labels, table is report$);