topic Re: hiding values in listbox in QlikView

hiding values in listbox

thanhphongle — Mon, 21 Dec 2015 09:04:51 GMT

Hello community,

is there any way to hide specific values depending on other fields in a listbox?

Example:

This is my datebase

What I want to create is a listbox which only shows the products with costs over 1000.

Listbox

This Listbox ignores/hides the product A as its cost is below 1000.

Is there any way how to create a listbox like this?

tresB — Mon, 21 Dec 2015 09:07:45 GMT

Instead of selecting the field directly in the list box, use expression like:

If(Cost>=1000, Product)

Kushal_Chawda — Mon, 21 Dec 2015 09:11:30 GMT

If you specifically want to create the Listbox then write below expression in listbox

=aggr(if(sum(Cost)>1000,Product),Product)

awhitfield — Mon, 21 Dec 2015 09:16:46 GMT

See the attached, create lookup with the expression:

If(Cost>=1000, Product)

See sample qvw

Andy

Mark_Little — Mon, 21 Dec 2015 09:20:02 GMT

Hi,

Would depend how the data is kept in your data model, but for the example supplied it would be

If(Cost>=1000, Product)

As a few people have already suggested.

You could also do this is script as well in the load script.

If(Cost>=1000, Product) as ProductCost group.

Mark

thanhphongle — Mon, 21 Dec 2015 09:20:05 GMT

Thank you for your response! Every suggested solution is working well!