set analysis fro not null values

[arusanah]

I'm writing  set analysis for total charges where charge id is not null.

Sum({<[Charge ID]-={"' '"}, REVENUE_DATE={"<= $([REPORT DATE]) "}>} TOTAL_CHARGE_AMT)

but it doesn't seems to work . it gives me same result as sum(TOTAL_CHARGE_AMT). which is not right .

Any help is highly appreciated.

[arusanah]

keep up the Good work Sunny. I really appreciate all your help and I guess so does rest of qliker's.

[ysalvi43]

Hello 

There might be possibility of null in the row because of which set analysis is not able to quantify the results. suggestion would be replace that null to NA or unknown and then use below formula.

formula: {<Product1 = {"NA"}>} Sum( Sales)

Thanks