How I can apply conditional filter to count values?

Wed, 27 May 2015 23:12:08 GMT

Hi,

I have a problem, im new user in QV, I have the next table:

DATE_CREATION ID STATE

15/5/15 Q123456 PROC

16/5/15 Q789101 PROC

16/5/15 Q112131 EP

14/5/15 Q312456 EU

12/5/15 Q789121 PROC

17/5/15 Q152131 EP

28/5/15 Q153456 PROC

28/5/15 Q789131 PROC

28/5/15 Q192131 EP

I need count IDs in PROC that have expired more than 1 day (TODAY)

The result should be= 3. (Q123456, Q789101,Q789121)

Please.

Re: How I can apply conditional filter to count values?

pokassov — Thu, 28 May 2015 07:08:47 GMT

Hello!

Count({$<DATE_CREATION={'<$(=date(today()))'}, STATE={PROC}>} ID)

Thu, 28 May 2015 15:25:11 GMT

Hi Cepren,

It is exactly what I was looking for.

Thank you very much.