How do I show the number of visits of the day?

[schiappacasse]

Hello,

I need help with a KPI that shows the number of visits that must be made during the day.

This line works perfectly for me: Count ({$ <statements-request = {'AGENDA'}, technical-date = {'2018-02-16'}>} idsolicitudposventa),

but when replacing '2018-02-16' with Today () it stops counting and I need it to update itself.

[Digvijay_Singh]

One more try -

Count({<Date={"=$(=Date(today()))"}>}Date)

I tried above format and it worked for me.My 'Date' field appears in the right side if I show in the filter pane, means it is of date type.

[schiappacasse]

Hi sorry for my absence, I appreciate your solutions, but none worked ... I'll see another alternative

Bye and thanks!!!

[robert99]

Hi

Did you try DaysAgo? Or an if statement

and what was the other alternative?

[schiappacasse]

I dont know how to do this with the if statement,
but I was thinking on trying to create a new array with a loop,
the problem is that it seems that qlik sense have some limitations with that...Do you have any idea?

[robert99]

Count ({$ <statements-request = {'AGENDA'}>}

IF ( technical-date = TODAY()     ,   idsolicitudposventa,0))

or maybe use NUM(TODAY()) instead

But I would recommend DaysAgo (as per hic) I tend to use this now rather than if or a complex set analysis

Relative Calendar Fields

[schiappacasse · Accepted solution]

Nope, but i tried this and...BINGO!!!

sum({$<statements-request={'AGENDADA'}>} if(technical-date=Today(),1,0))

Thanks!!

[robert99]

Hi

That's good. unsure why count didn't work though

Maybe it should be without the ,0

I'm curious if taking the ,0 out would make any difference. And give the correct total. If you have a chance try it please and let me know.

Count ({$ <statements-request = {'AGENDA'}>}

IF ( technical-date = TODAY()     ,   idsolicitudposventa))

[zebhashmi]

That's Great!