Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write set analysis to get sum of sales for region where region is null;
i.e only null region sales
None of our expression is working:(
but below is working
script:
sample:
LOAD Product,
Category,
Type,
Sales,
Region
FROM
(ooxml, embedded labels, table is Sheet1);
FE:
Strighttable:
dim: Region [you can change according to your req]
Exp:
sum({$-<Region=-{}>}Sales)
You mentioned that non of "our" expression worked? Where did you try my method of creating a flag?
sorry sunny it will work i just tested with expressions of yours and mine of
sum({$<region={"=Len(Trim(region)) = 0"}>} sales)
sum({$<region={"=isnull(region)"}>} sales)
Can you share the qvw file?
PFA
So you meant that it did not work... but the flag will work