Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Filter not working

Hi All,

My Expression is

=Sum({[POS]<YearPeriod = {$(=Max(YearPeriod))},MonthPeriod = >}[POS Sales])+

sum({[POS]<YearPeriod = {$(=Max(YearPeriod))},MonthPeriod = ,[BP Category 1 ID] = {237599,17421}>}Sales)+

sum({[POS]<YearPeriod = {$(=Max(YearPeriod))},MonthPeriod = ,_HandlerID = {'P1%CHA'}>}Sales)

when i filter some other BP Category 1 ID in the table the above mentioned two id is not disappearing , cam any one give some idea for this to work

Tanks,

keke

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Filter not working

Your assigning a constant set of values to the field in your set expression. To consider user selections in that same field, you can use

Implicit Set Operators

-->

[BP Category 1 ID] *= {237599,17421}

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Filter not working

Your assigning a constant set of values to the field in your set expression. To consider user selections in that same field, you can use

Implicit Set Operators

-->

[BP Category 1 ID] *= {237599,17421}

View solution in original post

Highlighted
Creator II
Creator II

Re: Filter not working

Hi stefan,

    Amazing , thank you so much.