topic Count Rows in QlikView

Count Rows

Tue, 18 Jan 2011 04:21:15 GMT

Hi,

I want to count the specific rows, the records are shown below:

I want to count the rows whose completionDate<=DateEntered+7(days), and use MemberId as the dimension to show.

How to use set analysis to achieve?

Thanks.

Tue, 18 Jan 2011 05:07:05 GMT

When I remove the last row whose memberid is 16742755, then use set analysis:

count({1<CompletionDate={"<=$(=Date((DateEntered+10),'YYYY/MM/DD hh:mm:ss'))"}>}CountMemberId)

It makes sense, but if includes that row, this expression will not work.

jonathandienst — Wed, 19 Jan 2011 15:50:47 GMT

Isaac

Please be more specific:

Jonathan

daveamz — Wed, 19 Jan 2011 16:38:29 GMT

Hi Isaac,

Try to use a variable as vCheckDate=Date((DateEntered+10),'YYYY/MM/DD hh:mm:ss') then for the set analys formula use:

"count({1<CompletionDate={"<=$(vCheckDate)"}>}CountMemberId)"

Good luck!