topic Re: Unlocated data in QlikView

Unlocated data

areli1990 — Tue, 29 Mar 2016 17:34:17 GMT

Edit by Community Team member:

Please post your topics in English unless posting in a specific language section.

Topic translated by google translate.

---

Hello

Currently I have a base of premium customers, who need to monitor every month to see if they shopped.

I need you in the table appear only those without activity. (But not in my report as active

That is to say;
My client is 001 Premium (I have one with all ID) - but not in my report "January"

I need you on my table all those cases where they are in my table ID Premium vs the existing and just throw me what not to appear.

I could support

Thank you very much

swuehl — Tue, 29 Mar 2016 19:44:22 GMT

Do you want this in your script?

Maybe like

LOAD ClientID,

.....

FROM JanuaryReportTable;

LOAD ClientID as ClientNotExistInJanuary

FROM ClientTable

WHERE NOT EXISTS(ClientID);

In the UI, you may be able to get your results just by using the associatice logic, create a chart with dimension ClientID

and as expression

=Sum({<ClientID = e() >} 1)

Then select from your fact table January month, or any field value that filters your fact for January.

areli1990 — Tue, 29 Mar 2016 20:16:34 GMT

For Example:

swuehl — Tue, 29 Mar 2016 21:02:15 GMT

Have you tried the two approaches I described above?

If this is not working, could you upload a small sample QVW?

areli1990 — Wed, 30 Mar 2016 17:02:11 GMT

the expression does not work