Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Order and priority of applying filters in expression

Good day!

Colleagues, i need to consult with you about order and  priorities of applying filters in any expr.

As i know, expressions calculating can react to three sources of filters:

1. Current selection

2. Bookmark filter

3. Inside field filter

4. Searching inside field filter

Some example:

sum({[Bookmark filter] <City={[Inside field filter]}, Delivery_point={"=Searching inside field filter "} >}sales)

As far as i understand, these ways for liltering have such orders and priorities:

1.Searching inside field filter  - First in order, first priority

2.Inside field filter  - Second in order, second priority

3.Bookmark filter - Third in order, third priority

4.Current selection - Fourth in order, fourth priority

Could you correct me please, if i write some wrong?


Many thanks.

3 Replies

Re: Order and priority of applying filters in expression

It would be interesting to know if there is such an order of priority. AFAIK there isn't any priority.

andreyfcdk91
New Contributor III

Re: Order and priority of applying filters in expression

Thanks, dear)

MVP
MVP

Re: Order and priority of applying filters in expression

Interesting question.

I would rather look at this like the set identifier / bookmark in combination with the field modifiers define a set as a whole.

Is there an priority / order  in applying the field modifier to the base set identifier? I don't think so, and I believe it shouldn't.

As it shouldn't make a difference to the aggregation result if you make a manual selection in field A before you make a selection in B compared to first B, then A.

What do you think? Have you any hints that there is a priority in applying filter?

Regards,

Stefan

Community Browser