Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Select A, B, C
From Table Where (D=1)
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
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
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
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
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
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
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