how to get a count of the data upto selected date from all the data????

[#1]

Hi All,

how to get a count of the data upto selected date from all the data????

Data is:

Date                             Service ID

14/02/2010                 896846384ghhgfh

14/02/2010                  568956dgfd

14/02/2010                  568956dgfdfghd

15/02/2010                   dfygdfh6768

15/02/2010                   dfygdfh676856dg

16/02/2010                  dfygdfh676856dg345

if the user selects 14/02/2010 then count of service id is 3.

if the user selects 15/02/2010 then count of service id is 5.

if the user selects 16/02/2010 then count of service id is 6.

[er_mohit]

hiiii

try this

Count({<Date={"$(=Date)"}>}[Service ID])

[#3]

updated:

load

     Date,

     count(ServiceID) as count

     from table1

     Group by Date;

then on expression write

sum({$<Date>}count)

*********************************************************

or you can try

LOAD Date1,

     [Service-Id]

FROM

(ooxml, embedded labels, table is Sheet1);

and on expression---

Count({<Date1={"$(=Date1)"}>}[Service-Id])

[#4]

hi

I tried this also.

but i am getting the error invalid expression.

[#5]

hi

I tried this also.

but i am getting the error invalid expression.

[#6]

hi

I tried this also.

but i am getting the error invalid expression.

[manideep78]

Hi,

Change Date field to date type. Dates in the Date field should not be in text format.

Then take selected date in some variable like GetFieldSelections(Date);

after that take below expression in some text object

=Count({<Date={"<=$(vDate)"}>}[Service ID])

It worked for me.

see attached qvw

Hope this helps you.