How to make a filter by rows

[#1]

Hi,  I need to make a filer between two tables, one table has data on columns, and the other has de colum´s name in rows

and that my filter be like:

Filter:

---------

field1

field2

field3

field4

field5

..

..

Thanks!!!

[satishkurra]

Hi

Create Inline load table

Fields:

LOAD * Inline [

Fields

Field1

Field2 ];

[sunny_talwar]

What are you trying to do here. Having some difficultly in understand what is the end goal here, can you elaborate a little?

[#4]

for example: when I'll choose A, only it shows sum(A)

------------------------------

Table1:

load * Inline

[

  A,B,C,D

  1,3,5,6

  2,3,5,4

  2,3,5,7

  1,3,5,6

  2,4,4,4

];

//----------------------------

Table2:

load * Inline

[

  fields

  A

  B

  C

  D

]

[settu_periasamy]

You can try with 'Enable Conditional ' with the below expression in the Dimension Tab.

=SubStringCount(Concat($Field,'|'),'Field1')

Here $Field - is a system Fields (you can load the Labels with Data Island)

Customizable Straight Table

Sample Attached

[alexpanjhc]

you can use create a list box

[Kushal_Chawda]

may be u r looking for this

Advanced Filters: QlikView Design Technique

[settu_periasamy]

You can use the same expression (as i mentioned earlier) in the Expression Tab -> Conditional.

Sample Attached

[sunny_talwar]

Or this if its always going to be one selected value in Fields

=Sum($(=Fields))

[#10]

but if I have more than one table? $field will be too big!

how can I use only fields from a specific table?