Is it possible to remove one value in listbox?

[#1]

Hi~~i want to know that is it possible to remove "implemented" in the listbox of "Purpose".

Do i need to change in script? But in the script, it just show like this:

So, what should i do?

[its_anandrjs]

Hi,

Are you trying this for chart

In expression write your expression like

Count({<Purpose = {'Recovery','User request' >}Your sum or count Value)

Or

If use in dimension then write calculated dimension for Purpose

=If(Purpose='Recovery','Recovery',

  If(Purpose='User Request','User Request'))

Or

=If(Purpose <>'Implementation',Purpose)

[its_anandrjs]

For purpose write like

=If(Purpose <>'Implementation',Purpose)

Instead of

=If(Purpose = 'Implementation',Purpose) in place of = use <> (Not equals)

[arjunkrishnan]

Hai nicole_kesi,

It's Possible One To Remove The Row Values In List Box..You May Write  Expression  in List Box Is't Possible

I Just  try Simple  List Box Expression It May Useful For U...

O/p Like That

If(Purpose<>'Implementation',Purpose)

[#5]

Use this Calculated Dimension

=If(Match(Purpose,'Implementation')>0,Purpose)

and tick Supress Null check box

[arsal_90]

Hi Wang can u post your expression not dimension expression

[arsal_90]

Wang

is it possible for you to post your sample qvw

[its_anandrjs]

Hi Wang,

Instead of doing this in the Calculated dimension as well as with if condition. If you load another field in the load script like for Purpose field in the table load and then use that field see like

Load

Purpose

If(Purpose<>'Implementation',Purpose) as PurposeExcept_Imple,

Field

..

..

From Location;

And use this field PurposeExcept_Imple but give your understandable name

Regards

[#9]

Is it like this?

But the red color bar(Implementation) still there

[arsal_90]

Wang

All thins is right Can u post your QVW.  and Weng why are you using two expressions. You just use this expression in your expression

Count({<Purpose={"Recovery","User Request"}-{"Implementation"}>} Purpose)

or  Count({<Purpose-={"Implementation"}>} Purpose)

Hope it will help you out