Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
For Example:
Have you tried the two approaches I described above?
If this is not working, could you upload a small sample QVW?
the expression does not work