topic Re: text box issue in QlikView

text box issue

vipin_mishra479 — Sat, 04 Aug 2012 05:05:57 GMT

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')

Re: text box issue

senpradip007 — Sat, 04 Aug 2012 06:03:03 GMT

Hi vipin

your question is not understandavle, pls clarify your question.

cheers

Pradip

Re: text box issue

vipin_mishra479 — Sat, 04 Aug 2012 06:54:05 GMT

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

Re: text box issue

IAMDV — Sat, 04 Aug 2012 17:49:02 GMT

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,