topic expression help!! in QlikView

expression help!!

hopkinsc — Tue, 24 Jun 2014 13:35:53 GMT

Hi all,

I am trying to calculate how many days in the current month have a [Visit_ID] of 4 but i can't seem to find the answer.

Can anyone help please?

MayilVahanan — Tue, 24 Jun 2014 13:51:35 GMT

Try like this

Count({<Visit_ID = {4}, Month={'$(=Month(Today()))'}>} Days)

hopkinsc — Tue, 24 Jun 2014 15:29:53 GMT

Hi, thanks,I don't have a field for Days, and the month needs to be taken from a date field..

here is what i want in a bit more detail...

i want to see which salesmen have worked full or half day.

A full days work is equal to them doing 4 visits, and a half day is them doing 2 visits per day..

I have attached a sample..

so what i want is a variable to show if the salesman have done a full days work (4 visits) or half days work (2 visits) for the current month

hopkinsc — Tue, 24 Jun 2014 18:30:23 GMT

Does anyone know the answer to this?

Tue, 24 Jun 2014 19:11:34 GMT

Hi Try this:

Create a simple table with the dimensions:

then add the next expression:

So you will have days worked by Salesman and by month.

I attached the .qvw with the example.

maxgro — Tue, 24 Jun 2014 19:46:24 GMT

count( {$ <Date={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}> } Visit_ID) / 4