topic Re: How to Ignore Other Filter Criteria in QlikView

How to Ignore Other Filter Criteria

Thu, 14 May 2015 23:20:39 GMT

Hello,

I have a several tables with date fields that link together by ID:

Table 1:

[ID]

[A-Date]

[A-Count]

Table 2:

[ID]

[B-Date]

[B-Count]

When I make selections on date fields separately, it works fine.

A-Date = 2014 returns A-Count or

B-Date = 2014 returns B-Count

But if I make selections on multiple date fields, i.e.

A-Date = 2014 and B-Date = 2014

it only shows me a subset of A-Count and B-Count for records that have the same ID

How would I approach this issue if it is necessary to keep the ID link? Is the best solution to use set analysis to ignore field selections? Thanks!

-Jason

Anonymous — Thu, 14 May 2015 23:59:20 GMT

Hey Jason,

My stab at it is to use an expression, (Chart - Straight Table) with ID as your dimension or what ever you may use

=count({<A-Date=>}[B-Count])

- what this does is Count, [B-Count] based on selection and ignore [A-Date]

and vice versa for [A-Count].

Hope this is something you're looking for

MarcoWedel — Fri, 15 May 2015 06:28:44 GMT

‌please post sample data and expected result.

regards

Marco

jonathandienst — Fri, 15 May 2015 06:35:17 GMT

You could use a set expression like this:

{<[A-Date]=P([A-Date]), [B-Date]>+<[B-Date] = P([B-Date]), [A-Date]>}

(Selected value(s) of A-Date ignoring selection on B-Date, unioned with selected value(s) of B-Date ignoring selection on A-Date.

jonathandienst — Fri, 15 May 2015 06:37:53 GMT

It could even be a simple as

{<[A-Date]>+<[B-Date]>}

A union of selections (including B-Date) ignoring A-Date selections and selections (including A-Date) ignoring B-Date...