qlik

[prashantsanchet]

How to write set analysis to get sum of sales for region where region is null;

i.e only null region sales

[Chanty4u]

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)

[sunny_talwar]

You mentioned that non of "our" expression worked? Where did you try my method of creating a flag?

[Chanty4u]

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)

[sunny_talwar]

Can you share the qvw file?

[Chanty4u]

PFA

[sunny_talwar]

So you meant that it did not work... but the flag will work