topic Re: How to make a filter by rows in QlikView

How to make a filter by rows

Mon, 11 Apr 2016 16:38:32 GMT

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!!!

Re: How to make a filter by rows

satishkurra — Mon, 11 Apr 2016 16:50:50 GMT

Create Inline load table

Fields:

LOAD * Inline [

Fields

Field1

Field2 ];

Re: How to make a filter by rows

sunny_talwar — Mon, 11 Apr 2016 16:51:51 GMT

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

Re: How to make a filter by rows

Mon, 11 Apr 2016 16:55:40 GMT

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

]

Re: How to make a filter by rows

settu_periasamy — Mon, 11 Apr 2016 17:09:28 GMT

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

Re: How to make a filter by rows

alexpanjhc — Mon, 11 Apr 2016 17:10:45 GMT

you can use create a list box

Re: How to make a filter by rows

Kushal_Chawda — Mon, 11 Apr 2016 17:22:47 GMT

may be u r looking for this

Advanced Filters: QlikView Design Technique

Re: How to make a filter by rows

settu_periasamy — Mon, 11 Apr 2016 17:31:02 GMT

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

Sample Attached

Re: How to make a filter by rows

sunny_talwar — Mon, 11 Apr 2016 17:33:53 GMT

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

=Sum($(=Fields))

Re: How to make a filter by rows

Mon, 11 Apr 2016 17:39:28 GMT

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

how can I use only fields from a specific table?

Re: How to make a filter by rows

settu_periasamy — Mon, 11 Apr 2016 17:41:39 GMT

Good to know. Thank you..

Re: How to make a filter by rows

sunny_talwar — Mon, 11 Apr 2016 17:48:51 GMT

You can use set analysis:

=SubStringCount(Concat({<$Table = {'TableName'}>}$Field,'|'),'Field1')

Re: How to make a filter by rows

settu_periasamy — Mon, 11 Apr 2016 18:01:08 GMT

You need create separate table with needed fields ( data island).. i think you already created like that..

Re: How to make a filter by rows

MarcoWedel — Mon, 11 Apr 2016 22:17:08 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco