Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vipin_mishra479
Contributor II

text box issue

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

1 Solution

Accepted Solutions
Luminary
Luminary

Re: text box issue

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

3 Replies
senpradip007
Valued Contributor III

Re: text box issue

Hi vipin

your question is not understandavle, pls clarify your question.

cheers

Pradip

vipin_mishra479
Contributor II

Re: text box issue

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

Luminary
Luminary

Re: text box issue

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

Community Browser