topic Re: How to show List box values conditional? in QlikView

How to show List box values conditional?

Suus — Wed, 19 Mar 2014 11:19:14 GMT

Hi,

Hope someone can help with the following.

I have created a list box on a dimension Klantnaam in my app.

In this I show the expression value sum([Te Factureren Bedrag NC])+sum([Te Factureren Bedrag FP])

As you can see 'Abstergo' and 'Autolease' show a value of 0.

I would like them to turn 'grey', of exclude from the selection.

How do I achieve this?

Regards, Suzan

Re: How to show List box values conditional?

alexandros17 — Wed, 19 Mar 2014 11:21:33 GMT

The best option is to use a table or a Chart, not a list box,

with a chart you may exclude by dimension or setting "exclude 0 values"

Re: How to show List box values conditional?

simondachstr — Wed, 19 Mar 2014 11:23:26 GMT

Did you try to suppress null values on the dimension property or suppress zero values on the presentation property?

Re: How to show List box values conditional?

rustyfishbones — Wed, 19 Mar 2014 11:23:57 GMT

Create a List Box Expression to only show values greater than 0

IF(SUM([Te Factureren Bedrag NC]) + SUM([Te Factureren Bedrag FP]) >0 , [Klant Naam])

Re: How to show List box values conditional?

jonathandienst — Wed, 19 Mar 2014 11:30:32 GMT

You don't have many options when you display data like this in a list box. You could hide the elements containing 0 values by using a conditional expression in the list box - but this removes them so they are no longer visible. You could also trigger a selection change that deselects those values - this will give them a grey unavailable background but this will prevent the display of the amount expression and cause the others to all turn green (selected).

Alternatively, change to pivot or straight table, but you will lose the horizontal flow...

HTH

Jonathan

Re: How to show List box values conditional?

rustyfishbones — Wed, 19 Mar 2014 11:30:34 GMT

Sorry try this

Re: How to show List box values conditional?

veidlburkhard — Wed, 19 Mar 2014 11:32:30 GMT

Hi Suzan,

seems the list box is not the adaquate object for these kind of things. What you can try, if you will stick to the list box, is to go to the 'Sort' tab and mark sorting by 'Expression' where you enter your expression sum([Te Factureren Bedrag NC])+sum([Te Factureren Bedrag FP]) and click on 'Descending'. So only the high values are shown and normally you should not see the zero values.

If this is not feasible for you, please try a straight table.

Hope this helps

Burkhard

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 11:52:04 GMT

Thanks, your expression gave an error.

I put this with altered brackets on Expression Tab, field 'Conditional', but nothing happens.

aggr(if(sum(([Te Factureren Bedrag NC])+sum([Te Factureren Bedrag FP]))>0,[Klant Naam]),[Klant Naam])

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 11:53:05 GMT

Thanks, tried this before asking the question on Community... Is ok, but not a real beauty ;-), so hope I find an even nicer answer...

Re: How to show List box values conditional?

rustyfishbones — Wed, 19 Mar 2014 11:55:03 GMT

Hi Suzan,

not on the Expression Tab

Create a List Box Expression and add

aggr(if(sum(([Te Factureren Bedrag NC])+sum([Te Factureren Bedrag FP]))>0,[Klant Naam]),[Klant Naam])

you would do it by selecting Expression from the drop down list on the list box properties, like below

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 12:21:33 GMT

Both options aren't available in a list box

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 12:26:52 GMT

Thanks, another new feature 😉

Unfortunately it gives a blank result.

I get a list box withiout values...

No worries... The Table workaround is good enough.

Unless you really want to pitbull through 😉

Re: Re: How to show List box values conditional?

rustyfishbones — Wed, 19 Mar 2014 12:28:15 GMT

Hi Suzan,

Please see the attached

Regards

Alan

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 12:29:35 GMT

Hi Jonathan,

I don't mind if they are no longer visible. Could you explain this option:

You could hide the elements containing 0 values by using a conditional expression in the list box - but this removes them so they are no longer visible.

Where and how do I make the conditional expression?

Regards, Suzan

Re: How to show List box values conditional?

Suus — Wed, 19 Mar 2014 12:36:10 GMT

Great! thanks. This works. Only small downside: It doesn't work with grey, but leaves out the dimension entirely.

Re: How to show List box values conditional?

Fri, 18 Sep 2015 09:12:53 GMT

Hi Alan,

I also ran across this requirement and thanks for the expression.

Downside to this approach is If we select the listbox with expression it will show only the selected values. My user wants to select multiple values and raises bug.

Can you pls let me know any alternative for this using list box.

P.S : I am a big fan of your Qlik tutorial channel in youtube . Thanks

Murali Krishna

Re: How to show List box values conditional?

kstroupe — Wed, 11 Jan 2017 15:04:15 GMT

Thank you this worked for me exactly like I wanted it too.