topic Re: Trying to get the count. in QlikView

Trying to get the count.

Wed, 25 Nov 2020 16:16:04 GMT

I have data as below...

ID DateEnd

3 10/31/2016.

Trying to get the count of ID's which has Date > today () and I am using the below expression,

count(if(date([DateEnd] >Today() ),[ID])) but it is not working

THnaks much

Re: Trying to get the count.

Digvijay_Singh — Tue, 20 Sep 2016 17:37:08 GMT

Looks like you misplaced one bracket,

count(if(date([DateEnd]) >Today(),[ID]))

Re: Trying to get the count.

swuehl — Tue, 20 Sep 2016 17:37:10 GMT

Try

count(if( [DateEnd] >Today() , [ID]))

Re: Trying to get the count.

Tue, 20 Sep 2016 18:06:04 GMT

Tried that...but no luck

Re: Trying to get the count.

swuehl — Tue, 20 Sep 2016 18:08:22 GMT

Are your dates correctly intepreted by QV?

Why don’t my dates work?

Re: Trying to get the count.

Tue, 20 Sep 2016 18:11:14 GMT

yeah...when I put in listbox it is in the following format....10/31/2016

Re: Trying to get the count.

sunny_talwar — Tue, 20 Sep 2016 18:13:41 GMT

How about this:

LOAD ID,

Date(Date#(DateEnd, 'MM/DD/YYYY')) as DateEnd

FROM....

Count({<DateEnd = {"$(='>' & Date(Today()))"}>} ID)

Re: Trying to get the count.

Anil_Babu_Samineni — Tue, 20 Sep 2016 18:20:13 GMT

Try like this using set expression

count({<[DateEnd] = {'=$(=>Today())'} >} ID)

Or script level

Load id, dateend where dateend => today();

Re: Trying to get the count.

vishsaggi — Tue, 20 Sep 2016 18:21:18 GMT

It worked fine with this: Is your data coming from somewhere or just trying on some test data as mentioned below.

And hope there is no additional characters beside date like [10/31/2016.]

LOAD * INLINE [

ID, DateEnd

3, 10/31/2016

];

Textbox: I used stefan expression = count(if( [DateEnd] >Today() , [ID]))

It displays 1.

Re: Trying to get the count.

Tue, 20 Sep 2016 18:37:58 GMT

Here comes my herroooo

Re: Trying to get the count.

swuehl — Tue, 20 Sep 2016 18:43:40 GMT

Pavana alva wrote:

yeah...when I put in listbox it is in the following format....10/31/2016

So I guess you either haven't read Henric's blog post (which I would recommend anyway) I've linked to or you haven't closely looked at the images titled 'correct' and 'incorrect' .

Re: Trying to get the count.

Tue, 20 Sep 2016 18:55:17 GMT

Yeah.My bad.Thank you very mcuh