topic Table data filter in QlikView

Table data filter

Fri, 18 Oct 2013 09:12:16 GMT

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

Re: Table data filter

Fri, 18 Oct 2013 09:16:43 GMT

Select A, B, C

From Table Where (D=1)

Re: Table data filter

Fri, 18 Oct 2013 09:18:41 GMT

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

MayilVahanan — Fri, 18 Oct 2013 09:19:57 GMT

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

kaushiknsolanki — Fri, 18 Oct 2013 09:20:37 GMT

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

Re: Table data filter

Anonymous — Fri, 18 Oct 2013 09:22:22 GMT

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

Re: Table data filter

MayilVahanan — Fri, 18 Oct 2013 09:27:11 GMT

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

Re: Table data filter

Fri, 18 Oct 2013 09:39:06 GMT

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

Re: Table data filter

Anonymous — Fri, 18 Oct 2013 09:41:42 GMT

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