Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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.

Tags (1)
1 Solution

Accepted Solutions
pokassov
Valued Contributor

Re: Count Records Less than Date Selection in Listbox

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
Valued Contributor

Re: Count Records Less than Date Selection in Listbox

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

Re: Count Records Less than Date Selection in Listbox

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

Highlighted

Re: Count Records Less than Date Selection in Listbox

Attaching your qvw for reference

Best,

Sunny

Not applicable

Re: Count Records Less than Date Selection in Listbox

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

Re: Count Records Less than Date Selection in Listbox

Glad to help.

Best,

Sunny