Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Manlyhero
Contributor II
Contributor II

How to avoid filter in measure

Hellow I have a measure which derived from each other:

rangesum(Above((sum({<[type]={'Circle'}>}[amount])) , 1, rowno()))*Avg(1)

This statement gives me the total amounts which type is CIRCLE for every month.

Some of my filters are Year, Month and Date filter and I want to above statement excluded these filters.

At first results like below

1.jpg
but when I select 2002-Jan than Opening will be 0
3.jpg
Any suggestion how to achive that?

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Within your set { }, list the fields you want to ignore filter for

rangesum(Above((sum({<[type]={'Circle'}, Year, Month, Date >}[amount])) , 1, rowno()))*Avg(1)

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Within your set { }, list the fields you want to ignore filter for

rangesum(Above((sum({<[type]={'Circle'}, Year, Month, Date >}[amount])) , 1, rowno()))*Avg(1)

Manlyhero
Contributor II
Contributor II
Author

Thank you for your reply but it didn't work. Still when I select the Year or Month or Date  opening changes

Manlyhero
Contributor II
Contributor II
Author

Hi @Lisa_P  I solve my problem by changing the set expression completely I used as of table and followed this blog post and also the view from youtube about the master table.

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

https://www.youtube.com/watch?v=ek_ITfvCnHw

 

But eventually, to exclude the fields I added them new set expression like you suggest because I will accept you answer. Have a nice day