topic Count in QlikView

Count

samuel_brierley — Mon, 02 Sep 2013 11:12:28 GMT

Hi first of all thanks for any help,

What Im looking for i think is relativly simple,

all I want the expression to do is count everything that is less than the date selected.

count ( {$<[Fault Id]={"<[Date Detected]"}>} [Fault Id] )

so basically count the fault ID if the date detected is less than the date I select using a calender

nizamsha — Mon, 02 Sep 2013 11:16:24 GMT

count ( {$<[Fault Id]={"<$(=Date([Date Detected]))} [Fault Id] )

michael_maeuser — Mon, 02 Sep 2013 11:19:29 GMT

is the fault id a date field? if so, make sure it is also loaded with date(fault id) as fault id

MayilVahanan — Mon, 02 Sep 2013 11:36:27 GMT

Try like this

count ( {$<[Fault Id]={"=[Fault Id]<[Date Detected]"}>} [Fault Id] )

v_iyyappan — Mon, 02 Sep 2013 11:36:59 GMT

Use like this

=count({$<[Date Detected]={"<$(=Date([Date Detected]))} [Fault Id])

Regards,

CELAMBARASAN — Mon, 02 Sep 2013 11:41:00 GMT

Hi,

Try with this

count ( {<[Date Detected]={"<$(=Date(vDateSelected,'Your Date Format'))"}>} [Fault Id])

er_mohit — Mon, 02 Sep 2013 11:43:54 GMT

Try this

count ( {$<[Date Detected]={"<$(=Date([Date Detected]))"}>} [Fault Id] )