text box issue

[vipin_mishra479]

how can i remove null value from text box.......

i have use this expression

=num((sum(aggr(sum(amount)/sum(aggr((qty),model,product)),product))),'##.0')

[senpradip007]

Hi vipin

your question is not understandavle, pls clarify your question.

cheers

Pradip

[vipin_mishra479]

I have pivot table there reflect sum of amount is 26 lacs same value i reflect in text box which is wrong but when i suppress null in pivot table then value are come 24 lacs which is correct but in text box value reflect in 26 lacs thats y i am asking how to remove null value in text box

[IAMDV · Accepted solution]

Vipin,

Now I understand the issue. So which fields have NULLS? Meanwhile try this expression and if possible please post the sample QVW file.

=num((sum(aggr(sum({<amount={"*"}>} amount)/sum(aggr((qty),model,product)),product))),'##.0')

Thanks,

DV

www.QlikShare.com