topic Re: Suppress 0 values in listbox in QlikView

Suppress 0 values in listbox

Anonymous — Wed, 03 Jun 2015 11:09:34 GMT

I have a listbox which displays count of products for each line. I want to suppress the line which contain 0.

I am using the following formula to generate the count:

count({$ <

[Financial Year] = {2014},

[Financial Period] = {1,2}

>}[Product num])

count({$ <

[Financial Year] = {2013},

[Financial Period] = {11,12}

>}[Product num])

It generates the list as expected but I just want to suppress the 0 values How do I suppress the 0 values in listbox?

Thank you in advance.

Re: Suppress 0 values in listbox

alexandros17 — Wed, 03 Jun 2015 11:13:39 GMT

try with:

If(

count({$ <

[Financial Year] = {2014},

[Financial Period] = {1,2}

>}[Product num])

count({$ <

[Financial Year] = {2013},

[Financial Period] = {11,12}

>}[Product num])

=0, Null(),

count({$ <

[Financial Year] = {2014},

[Financial Period] = {1,2}

>}[Product num])

count({$ <

[Financial Year] = {2013},

[Financial Period] = {11,12}

>}[Product num])

)

let me know

Re: Suppress 0 values in listbox

rubenmarin — Wed, 03 Jun 2015 11:16:53 GMT

Hi Ranajit, maybe using a calculated expression, in the list box preoperties, instead of selecting the field, go to the bottom of that list and select <Expression>, you can use this expression:

Aggr(If(count({$ <[Financial Year] = {2014}, [Financial Period] = {1,2} >}[Product num]) +

count({$ <[Financial Year] = {2013},[Financial Period] = {11,12}>}[Product num])<>0, [Product num]), [Product num])

Not tested.

Re: Suppress 0 values in listbox

jonathandienst — Wed, 03 Jun 2015 11:24:01 GMT

No alternative but to calculate the amount twice:

If(Count({<[Financial Year] = {2014}, [Financial Period] = {1,2}>

+ <[Financial Year] = {2013}, [Financial Period] = {11,12}>} [Product num]) <> 0,

Count({<[Financial Year] = {2014}, [Financial Period] = {1,2}>

+ <[Financial Year] = {2013}, [Financial Period] = {11,12}>} [Product num]))

PS I refactored your two terms into a set expression union '+'

Re: Suppress 0 values in listbox

Anonymous — Wed, 03 Jun 2015 16:07:51 GMT

I tried this before. it does suppress the 0 values but I want it not to show the line represented by the 0 value.

Re: Suppress 0 values in listbox

Anonymous — Wed, 03 Jun 2015 16:10:35 GMT

I tried this before as well. It does supress the 0 but I do not want to show the entire line represented by the 0 value

Re: Suppress 0 values in listbox

Anonymous — Wed, 03 Jun 2015 16:11:45 GMT

I tried it but it did not work. Thanks for your help.

Re: Suppress 0 values in listbox

tcullinane — Wed, 03 Jun 2015 16:35:16 GMT

if you have multiple expressions you will need the if statement containing the calculation of the condition in each, else they will continue to force a blank cell.

Re: Suppress 0 values in listbox

alexandros17 — Wed, 03 Jun 2015 19:21:07 GMT

please share your qvw

Re: Suppress 0 values in listbox

Anonymous — Thu, 04 Jun 2015 14:27:50 GMT

I can't share the QVW, its for work. I'll make a qvw and upload it.