topic Re: Amount display in list box in QlikView

Amount display in list box

Wed, 16 Jan 2013 09:27:47 GMT

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

Re: Amount display in list box

nirav_bhimani — Wed, 16 Jan 2013 09:52:43 GMT

Hi,

Try this

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

Regards,

Nirav Bhimani

Re: Amount display in list box

Wed, 16 Jan 2013 10:06:30 GMT

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?

Re: Amount display in list box

nirav_bhimani — Wed, 16 Jan 2013 10:08:55 GMT

HI,

Please share a demo file.

Regards,

Nirav Bhimani

Re: Amount display in list box

kouroshkarimi — Wed, 16 Jan 2013 10:15:29 GMT

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

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

Re: Amount display in list box

kumarnatarajan — Wed, 16 Jan 2013 10:23:54 GMT

HI,

Please find the attached file

Re: Amount display in list box

Thu, 17 Jan 2013 02:45:16 GMT

Seems it doesn't work...

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

Re: Amount display in list box

Thu, 17 Jan 2013 02:46:15 GMT

Hi,

I have attached a test file.

Re: Amount display in list box

Thu, 17 Jan 2013 03:00:40 GMT

Hi,

I have updaloaded a test qvw.

Re: Amount display in list box

kumarnatarajan — Thu, 17 Jan 2013 05:46:20 GMT

Hi,

Please find the attachment, it may helps you