Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Records Less than Date Selection in Listbox

I've created a test file where I am attempting to count records less than or equal to a variable date value.  When a selection is made in the YearQuarter listbox, I want the count to include all records <= the variable vFPYQuarterEnd. 

In the example, if you select 2014-3, the variable vFPYQuarterEnd = 9/30/2014 and all records less than or equal to this date should be counted, including those that do not fall within the the actual quarter.  I would expect to see a count of 12 records.  Instead, I am receiving a count of 9 records which represents on the records in the 2014-3.

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

Hi!

You have to exclude YearQuarter from filter like this:

='# IDs <= Max Quarter End Date = ' & COUNT({$<

YearQuarter=,

MASTERDATE={"<=$(=$(vFPYQuarterEnd))"}

>} ID_NUM)

Sergey

View solution in original post

5 Replies
pokassov
Specialist
Specialist

Hi!

You have to exclude YearQuarter from filter like this:

='# IDs <= Max Quarter End Date = ' & COUNT({$<

YearQuarter=,

MASTERDATE={"<=$(=$(vFPYQuarterEnd))"}

>} ID_NUM)

Sergey

sunny_talwar

The issue is that when you select a yearQuarter it restrict your date to that particular quarter itself. If you want to ignore selection in YearQuarter you can use your expression like this instead:

=COUNT({$<MASTERDATE={"<=$(=$(vFPYQuarterEnd))"}, YearQuarter = >} ID_NUM)

HTH

Best,

Sunny

sunny_talwar

Attaching your qvw for reference

Best,

Sunny

Not applicable
Author

Thank you for the info from both of you.  It's working exactly as I wanted now.

sunny_talwar

Glad to help.

Best,

Sunny