topic how do i unselect a value from filter in QlikView

how do i unselect a value from filter

Anonymous — Fri, 27 Aug 2010 20:42:14 GMT

I dont want a value to appear in a filter,

for eg, i have column which has values a,b,c,d .When i have a list box on that column i dont want user to select C from the filter , how do i avoid the value to appear in the filter?

Thanks

how do i unselect a value from filter

Fri, 27 Aug 2010 21:02:32 GMT

You can Edit the select field....put Expression

for example:

IF(FIELD<>'C',FIELD)

what exacly you wanna....just remove a value from object...

to calculated in others objects you can use set analisys:

Something like

sum({$<FIELD=-{'C'}>} Sales)

how do i unselect a value from filter

stevedark — Sun, 29 Aug 2010 22:37:13 GMT

Hi there,

If you are dealing with only a small amount of data you may want to consider having two columns in your data model - one with and one without the values you don't want selected. There are a few ways of achieving this in the load script, the code suggested by Érico being one of them. If you are looking to exclude more than a couple values then the ApplyMap statement is a good one to use.

Once you have your two columns in the data model you can just choose which one you place into any list boxes.

Regards,
Steve