I have tried to write below script, it seems working. With below script [libA] [libB] are synthetic with "Date", "User", "Team", if "Activities" is filter in chart A, then chart B with "Points" display will go off. How can I remain chart B "Points" display with "Activities" is filter in chart A ?
[Result100]:
LOAD Distinct
"Date",
"User",
"Team",
100 as "Points",
Date("Date",'YYMMDD') & '-' & "User" as "myID"
from [libA] (qvd) where not match ("Activities", 'Activity6');
Concatenate
Load * from [libB] (qvd)
Where not Exists("myID");
Store Result100 into [libB] (qvd);
Drop Table [Result100];
---------------------------------------
[Result50]:
LOAD Distinct
"Date",
"User",
"Team",
50 as "Points",
Date("Date",'YYMMDD') & '-' & "User" as "myID"
from [libA] (qvd) where match ("Activities", 'Activity6');
Concatenate
Load * from [libB] (qvd)
Where not Exists("myID");
Store Result50 into [libB] (qvd);
Drop Table [Result50];
---------------------------------------
Load [libA] (qvd);
Load [libB] (qvd);
