Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

schiappacasse
New Contributor II

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

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.

1 Solution

Accepted Solutions
schiappacasse
New Contributor II

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

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

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

Thanks!!

17 Replies
mwoolf
Honored Contributor II

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

Try using Date(Today(),'YYYY-MM-DD')

schiappacasse
New Contributor II

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

I replaced my line for:

Count ({$ <statements-request = {'AGENDA'}, technical-date = Date(Today(),'YYYY-MM-DD')>} idsolicitudposventa) and it stop counting...

Digvijay_Singh
Honored Contributor III

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

If technical-date is of type date then this should work -


Count ({$ <statements-request = {'AGENDA'}, technical-date = {"=$(=date(today())"}>} idsolicitudposventa)

zebhashmi
Valued Contributor

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

Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=today())}>} idsolicitudposventa)

schiappacasse
New Contributor II

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

Thanks I tried but it doesnt work...

schiappacasse
New Contributor II

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

Thanks but it doesnt work...

robert99
Valued Contributor II

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

Hi

You could try DaysAgo

It would need to be done in script

Today() - Date as DaysAgo,

then DaysAgo = {0} for today

or use an 'if' if you can't get it to work. I feel like throwing my computer out the window when simple date set analysis like this won't work. But monthsAgo and DaysAgo (or using an if statement instead) always works for me

Relative Calendar Fields

zebhashmi
Valued Contributor

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

can you try this

Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=floor(today()))}>} idsolicitudposventa)

your technical-date is timestam or date?

may be this

Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=floor(Date(Today(),'YYYY-MM-DD'))}>} idsolicitudposventa)

schiappacasse
New Contributor II

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

It counts but throws me 0, when the output should be 3

Community Browser