Unlocated data

[areli1990]

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 · Accepted solution]

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]

For Example:

[swuehl]

Have you tried the two approaches I described above?

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

[areli1990]

the expression does not work