Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Amount display in list box

I created a list box, made a IF expression in General>Field, and made a Sum() expression. If I didn't make any selction, it would display

Forecast     35506

Sales         40000

If I selected Sales it would display

Forecast    

Sales          40000

How can I get it to display

Forecast     0

Sales          40000

9 Replies
nirav_bhimani
Contributor III

Re: Amount display in list box

Hi,

Try this

=if(GetFieldSelections(FieldName) = 'Forecast ',Expression ,0)

Regards,

Nirav Bhimani

Not applicable

Re: Amount display in list box

Thank you, but the values in the list box are not fixed, it could also be "Hold", "CB"... Is there any more flexible way on this?

nirav_bhimani
Contributor III

Re: Amount display in list box

HI,

Please share a demo file.

Regards,

Nirav Bhimani

kouroshkarimi
Contributor III

Re: Amount display in list box

assuming the field you are summing is called 'Value' then you could do something like:

if(isnull(sum(value)),0,sum(value))

kumarnatarajan
Valued Contributor

Re: Amount display in list box

HI,

Please find the attached file

Not applicable

Re: Amount display in list box

Seems it doesn't work...

Upload a test qvw, I want '0' displayed rather than blank when making some selection.

Not applicable

Re: Amount display in list box

Hi,

I have attached a test file.

Not applicable

Re: Amount display in list box

Hi,

I have updaloaded a test qvw.

kumarnatarajan
Valued Contributor

Re: Amount display in list box

Hi,

Please find the attachment, it may helps you

Community Browser