Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table data filter

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

8 Replies
Not applicable
Author

Select A, B, C

From Table Where (D=1)

Not applicable
Author

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



Thanks & Regards,
Mayil Vahanan R
kaushiknsolanki
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
bill_markham

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

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

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

bill_markham

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