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'
if(Status = 'Y','Active',if( Status = 'N','Inactive','All')) as Field Name
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
can you share sample data
LOAD * INLINE [
//STATUS A=ACTIVE, STATUS I= INACTIVE , STATUS A & I= ALL
if status contains both A& I you want show 'All' right
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
LOAD * Inline
and use StatusDim in your listbox/filter
Retrieving data ...