Count with a specific criteria

[#1]

Hi,

I am building a report for our Consultations department.

Currently all the "Details" of clients who visit the office, is captured on an excel spread sheet.

This list goes back a few years.

I am trying to count the number of times that a client has visit our offices. That is straight forward. However, when I Count, and start using the list boxes to select i.e yesterdays date, it only indicates 1( as client only visited once that day).

Is it possible to bring up the names of clients who visited yesterday, but show me the combined total times client has visit, and not 1?

[sushil353]

Hi,

you can modify your expression like this:

say the listbox/field name containing time i.e Yesterday.. is TimeDim

then in your expression = Count({<TimeDim=>}Visit_id)

or Count({1}Visit_id)

HTH

Sushil

[anbu1984]

Can you provide sample app

[ashfaq_haseeb]

Hi,

Please upload sample data and expected output.

Regards

ASHFAQ

[#5]

Here is the sample data.

[#6]

Hi Sushil,

This does work, but how do I get it to now change and only show me the data, coinciding, to those who visit the office yesterday?

[anbu1984]

Not able to open your QVW file

[#8]

What do I need to do in order for you to be able to open it?

[ashfaq_haseeb]

HI,

Your qvw cannot be opened

you need to attach it again

Regards

ASHFAQ

[anbu1984]

Can you re-upload QVW