Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

andrechristophe
Not applicable

Locate missing values automatically after recharging

Hello,

I have several qvw which are reloaded one after the other or in parallel and I try to highlight automatically the presence of the value ' Anomaly mapping ' generated during applymap.

I wish to make it most automatically possible, for example by scanning every qvw of a directory to find this value in the whole of the data. The objective is to locate quickly the anomaly to go back to the mapping in cause and update the data sources before reloading.

Is there an application to make it or a macro?

Beforehand thank you.

Christophe

1 Reply
Clever_Anjos
Not applicable

Re: Locate missing values automatically after recharging

Pseudo code:

t:

mapping LOAD * FROM YourMap;

table:

LOAD

    applymap('t',afield,'**') as afield

    otherfields

from yourqvd(qvd);

temp:

LOAD count(afield) as q resident where afield = '*';

if noofrows('temp')> 0 then

    temperror:

   LOAD afield resident where afield = '*';

   store temperror into temperror.csv(txt);

endif