Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?


8 Replies
Not applicable

Re: Table data filter

Select A, B, C

From Table Where (D=1)

Not applicable

Re: Table data filter

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?


Re: Table data filter


Try like this

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


In front end,

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


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

Re: Table data filter


     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.


Kaushik Solanki

Re: Table data filter


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

Re: Table data filter


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

Use Straight/Pivot table..

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

But, its show null value for D other than 1

Not applicable

Re: Table data filter


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

Re: Table data filter


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