Table data filter

[#1]

Hi all,

i need to filter data in a table object, i explain

i have a query like this  SELECT A,B,C,D from TABLE;

Field D values are 0-1

In table i need show only A-B-C when field d = 1

Can u help me pls?

TYVM

[#2]

Select A, B, C

From Table Where (D=1)

[#3]

no, i need all values, so i can't filter it in query.

Iin qv document i have 2 table object, i need to show data with d=1 in first table and d=0 in the second.

ISN'T possibile filter it in table object?

ty

[MayilVahanan]

Hi

Try like this

SELECT A,B,C,D from TABLE Where D = 1;

or

In front end,

A, B, C are in dimension =Only({<D={1}>}D) as expression

Or

= If(D =1 , D) as dimension/Expression

[kaushiknsolanki]

Hi,

     See its not possible in text object, but you can use the Straight table which actually shows the same outout as table box but with the additional filter which you want.

Regards,

Kaushik Solanki

[Anonymous]

Simone

Use a Chart of type Straight Table and use calculated dimensions

     if ( D = 1 , A , null() )

and suppress nulls in your table

Best Regards,     Bill

[MayilVahanan]

HI

In table object, you can't do it like tat

Use Straight/Pivot table..

Or
in script,
Load A, B, C , If(D= 1, D) As D From tableName;

But, its show null value for D other than 1

[#8]

Hi,

If you are using QV 11, then use "Alternate State". Define 2 Alternate State D0 and D1 and define 2 list boxes for D one for filter 0 values another for value 1. Now create 2 tables one with Alternate state D0 another with D1

[Anonymous]

Gowri

I like your suggestion there, as in Alternate States.  I am getting more and more into them, but keep forgetting to actually use them.

Best Regards,     Bill