Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi sorry for my absence, I appreciate your solutions, but none worked ... I'll see another alternative
Bye and thanks!!!
Hi
Did you try DaysAgo? Or an if statement
and what was the other alternative?
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?
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
Nope, but i tried this and...BINGO!!!
sum({$<statements-request={'AGENDADA'}>} if(technical-date=Today(),1,0))
Thanks!!
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))
That's Great!