topic Re: List box data in QlikView

List box data

priyarane — Thu, 26 Feb 2015 10:03:59 GMT

Hi Experts,

I have to remove particular data from listbox like below

Dim1

0

50

100

150

250

800

and I want to remove only 50 from Listbox

Dim1

0

100

150

250

800

Thank you

Re: List box data

Gysbert_Wassenaar — Thu, 26 Feb 2015 10:11:52 GMT

Use an expression =if(Dim1 <> 50, Dim1) as field for the listbox

Re: List box data

priyarane — Thu, 26 Feb 2015 10:15:09 GMT

Thank you Gysbert

Re: List box data

Thu, 26 Feb 2015 10:16:34 GMT

Hi !

Try with the match function :

where match(Dim1, 50) = 0 - It will keep all values except 50

if you want to add values it's very simple : match(Dim1, 50, 'Value2', 'Value3') = 0 (if it is text values place them between quotes)

if want to work by inclusion do '>0', it will keep only the values of the list.

Re: List box data

mightyqlikers — Thu, 26 Feb 2015 10:17:00 GMT

Hi Priya,

use below expression in list box

=if(not Match(DIM,'50'),DIM)

Regards

Gamzee

Re: List box data

priyarane — Thu, 26 Feb 2015 11:45:55 GMT

Hi Marie,

Even its working perfect like this

=

if(match(Dim1,50)=0,Dim1)

Re: List box data

priyarane — Thu, 26 Feb 2015 11:50:05 GMT

Hi Gamzee,

Its woriking