# Qlik Sense App Development

New Contributor II

## Set analysis Today()

Post edited by Community Team member:

Please only post in English unless in a dedicated language section.

---

Hi,

I'm trying a helpdesk solution by Set Analysis structuring.

Have the following line input:

acTicketErstelldatum is in the data model as: illustrated 41235.46. That is my opinion ok.

Target: All tickets which were created today.

Sum({\$<acTicketErstellungsdatum={'date(today()'}>}[#ITTicket_erstellt_Zähler])

Can you help me here in troubleshooting?

Greeting

CS

1 Solution

Accepted Solutions
MVP

## Re: Set analysis Today()

May be this:

Sum({\$<acTicketErstellungsdatum={"=Num(Floor(acTicketErstellungsdatum)) = Num(Today())"}>}[#ITTicket_erstellt_Zähler])

7 Replies
MVP

## Re: Set analysis Today()

Sum({\$<acTicketErstellungsdatum={'\$(=Date(Today()))'}>}[#ITTicket_erstellt_Zähler])

MVP

## Re: Set analysis Today()

May be this:

Sum({\$<acTicketErstellungsdatum={"=Num(Floor(acTicketErstellungsdatum)) = Num(Today())"}>}[#ITTicket_erstellt_Zähler])

MVP

## Re: Set analysis Today()

Sum({\$<acTicketErstellungsdatum={'\$(=date(today())'}>}[#ITTicket_erstellt_Zähler])

But your field acTicketErstellungsdatum seems to be a timestamp in fact, so either create a pure date field in the script or try

Sum({\$<acTicketErstellungsdatum={">=\$(=num(Daystart(today()))<=\$(=num(Dayend(today()))"}>}[#ITTicket_erstellt_Zähler])

New Contributor II

## Re: Set analysis Today()

Hi,

Sum({\$<date(acTicketErstellungsdatum)={'\$(=Date(Today(),'DD-MM-YYYY'))'}>}[#ITTicket_erstellt_Zähler])

The function date(acTicket... compare with the function Date(Today(),'DD-MM-YYYY' has the similar result.

MVP

## Re: Set analysis Today()

This isn't going to work this way. You cannot have Functions (Date()) on the left hand side of the set analysis modifier.

New Contributor II

## Re: Set analysis Today()

Now i have vToday as a variable declarated, but the code still doesn`t work.

Count({\$<acTicketErstellungsdatum={'vToday'}>}[#ITTicket_erstellt_Zähler])

Can you find a another solution ?

Thanks

New Contributor II

## Re: Set analysis Today()

count({\$<acTicketErstellungsdatum={"=Num(Floor(acTicketErstellungsdatum)) = Num(Today())"}>}acTicketnr)