Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Skipping 1 selected filter for COUNT()

I have Portfolios and Positions. Each Portfolio has many positions for some date.

I have daterange selection but I vould like to calculate the count of positions for selected Portfolio without taking into account date range selected.

How can I do that?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

If you now have an expression like count(Positions), then you can make it ignore selection in a field by adding a set modifier. If your data field is named MyDate it would look like count({<MyDate=>} Positions).

For more information about set analysis see this document.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
fred_s
Partner - Creator III
Partner - Creator III

Please post a Qlikview file with (sample) data.

Gysbert_Wassenaar

If you now have an expression like count(Positions), then you can make it ignore selection in a field by adding a set modifier. If your data field is named MyDate it would look like count({<MyDate=>} Positions).

For more information about set analysis see this document.


talk is cheap, supply exceeds demand