Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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