topic Re: Filter Data In a Straight Table in QlikView

Filter Data In a Straight Table

jmonroe918 — Tue, 15 Sep 2015 19:07:23 GMT

I am trying to display 3 separate Straight Tables of data on one sheet. See the data loaded below.

Each table will display the Comments associated with each Division (the tables are split be Division).

How do I filter each table to only display the Comments from the associated Division?

Thanks

Number	Division	Comment
1	Division 1	Division 1; Comment 1
2	Division 1	Division 1; Comment 2
3	Division 1	Division 1; Comment 3
1	Division 2	Division 2; Comment 1
2	Division 2	Division 2; Comment 2
3	Division 2	Division 2; Comment 3
1	Division 3	Division 3; Comment 1
2	Division 3	Division 3; Comment 2
3	Division 3	Division 3; Comment 3

Re: Filter Data In a Straight Table

Oleg_Troyansky — Tue, 15 Sep 2015 19:19:25 GMT

I'd suggest to use set analysis with the filter on the field Division.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Filter Data In a Straight Table

saurabh5 — Tue, 15 Sep 2015 19:24:36 GMT

hi Jeff,

first in your load script split Comment column using subfield function.

subfield(Comment,';'2) as comment

subfield(Comment,';'1) as division

then create 3 tables and use set analysis to identfy only 1 division.

Re: Filter Data In a Straight Table

jmonroe918 — Tue, 15 Sep 2015 19:25:48 GMT

Oleg:

I was thinking the same thing, however I am struggling with where to put the Set Analysis string (and not sure of the context).

Jeff

Re: Filter Data In a Straight Table

jmonroe918 — Tue, 15 Sep 2015 19:33:31 GMT

Saurabh:

I'm not familiar with "subfield" and don't really understand why using it. It seems if I put the Set Analysis in the correct location (The data in the Comment Column is sample data. I just used "Division 1; Comment 1" as example data.

In which property should I put the string <Division = {'Division 1'}> (if that is the correct string)

Jeff

Re: Filter Data In a Straight Table

Oleg_Troyansky — Tue, 15 Sep 2015 19:38:01 GMT

Well, it depends on how you'd like to show your comments. If these are expressions, and there is another dimension (Number?) that identifies each comment uniquely, then you can use Set Analysis with the Only() function:

Only({<Division={Div1}>} Comment)

If Comment should be a Dimension, then I'd use a hidden expression that could help you filter the data, for example:

Count({<Division={Div1}>} Comment)

All you need is to find an aggregation function that can accept your Set Analysis.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense