tab_1:
LOAD
IN_ID,
IN_NAME,
COUNTRY,
IN_DOMAIN,
WORDS_RE,
KEY_CAT,
IN_TOTAL,
DATE_RESEARCHED
FROM [lib://source/QVD/ssms_src.qvd]
(qvd);
tab_2:
LOAD
"6S_ID",
"6S_ACC_NAME",
COUNTRY,
DOMAIN,
P_CATEGORY,
B_STAGE,
I_SCORE,
P_FIT,
P_SCORE,
"DATE",
UNIQUE_ID
FROM [lib://source/QVD/excel1_src.qvd]
(qvd);
tab_3:
LOAD
WV_ID,
WV_NAME,
COUNTRY,
WV_DOMAIN,
"URL",
EVENT,
REFERRER_DOMAIN,
UTM_SO,
UTM_MED,
"TOTAL",
DATE_VISITED
FROM [lib://source/QVD/excel2_src.qvd]
(qvd);
THIS TABLE I LOADED AND I AM TRYING TO ADD AN KPI USING THE SET ANALYSIS FUNCTION BUT THE COUNT IS SHOWING ZERO WHAT MIGHT BE THE REASON
