topic Re: Data filter in QlikView

Data filter

Anonymous — Tue, 03 Jul 2018 09:51:45 GMT

Hello,

Could you help me in solving of my request:

I have straight and pivot tables and I need to filter data by some values. For example, I have a table as showed below and I need to show for user only entries if the values in column "MatchStatus" do not equal to 'FT' or 'AT'

Match MatchStatus

1 FT

2 AT

3 3

4 45

Thank you!

Re: Data filter

stabben23 — Tue, 03 Jul 2018 09:57:41 GMT

Hi,

then use set analysis. Likethis:

sum({<MatchStatus -={'FT','AT'}>}YourValue)

Re: Data filter

Anonymous — Tue, 03 Jul 2018 10:08:28 GMT

Hi,

Thank you. I can use it for Dimension and Expression? Parameter YourValue what means?

Re: Data filter

stabben23 — Tue, 03 Jul 2018 10:15:52 GMT

This should be use in Expressions.

Expressions With set analysis will reduce Dimensions for you.

Set analysis should not to be use in calculated Dimensions.

YourValue is Your value that you want to aggregate.

Re: Data filter

Anonymous — Tue, 03 Jul 2018 10:58:03 GMT

OK, its clear. If I do not need to aggregate any data - only to filter entries in my table.

Re: Data filter

stabben23 — Tue, 03 Jul 2018 11:10:13 GMT

Then use this as Expression for ex:

Only({<MatchStatus-={'FT','AT'}>}MatchStatus)

Match as Dimension

Re: Data filter

Anonymous — Tue, 03 Jul 2018 11:12:44 GMT

Thanks. I'll check later and let you know how it works.

Re: Data filter

BalaBhaskar_Qlik — Tue, 03 Jul 2018 16:33:17 GMT

May be:

If(Not Match(MatchStatus,'FT','AT'),'MatchStatus')

Re: Data filter

Anonymous — Tue, 03 Jul 2018 16:56:02 GMT

As you see there is an error when I use proposed solution. Do you have any ideas why it does not work?

Re: Data filter

Anonymous — Tue, 03 Jul 2018 17:00:21 GMT

Thank you, but proposed solution does not filter data and shows every entry however FT entries replace by "-". Do you have any ideas how do not show entries by this criteria?

Re: Data filter

stabben23 — Wed, 04 Jul 2018 06:26:00 GMT

As I told you, set analysis should NOT be use in calculated Dimension, use it in Expression.

Re: Data filter

Anonymous — Mon, 09 Jul 2018 07:08:36 GMT

Thanks. It really works, but only in case when I have only this one expression. When I add the second expr. this filter does not work.