New field creation using existing field

[ashishbp]

Hello Friends,

Can any one tell me how to show in front end filter Status= Active , Inactive , All.

There is field in database as Status = Y, N .  I want to show third field also 'All'

Thanks

AP

[ChennaiahNallani]

Try this

if(Status = 'Y','Active',if( Status = 'N','Inactive','All'))  as Field Name

[ashishbp]

thanx for your response,

but if i am doing like that, I'm not able to see third field in filter it show only two fields

[ChennaiahNallani]

can you share sample data

[ashishbp]

LOAD * INLINE [

    FIELD, STATUS

    ABC, A

    EFG, A

    HIJ, I

    KLM, A

    NOP, I

];

//STATUS A=ACTIVE, STATUS I= INACTIVE , STATUS A & I= ALL

[ChennaiahNallani]

if status contains both A& I you want show 'All' right

[jonathandienst]

The best QV practice is to train your users that no selections = All, but failing that, you will have to load some additional data. Something like

StatusDim:

LOAD * Inline

[

    Status, StatusDim

    Active, Active

    Inactive, Inactive

    Active, All

    Inactive, All

];

and use StatusDim in your listbox/filter