Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sekrish
Contributor III
Contributor III

set expression evaluating to 0

Hi,

I have an app that has a guage control to show data about tickets we receive, the date they are created and the amount of time they take to resolve (among other things). I am looking for the guage needle to show the to total duration for tickets with a particular label but the below expression resolves to 0. any pointers?

SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">2021-01-01"}>} DURATION)

Labels (2)
3 Replies
Anil_Babu_Samineni

Please check the format and try like this

SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">$(=Date(YearStart(Today()),'Your Format of the field'))"}>} DURATION)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sekrish
Contributor III
Contributor III
Author

tried this
SUM({<tag_name={"ABC"},[time_created.autoCalendar.Date]={">$(=Date(YearStart(Today()),'YYYY/mm/dd'))"}>} DURATION)
still getting  0 ...

 

Anil_Babu_Samineni

Try to debug by yourself like

Date(YearStart(Today()),'YYYY/mm/dd')

What is this returning? If that returns something find out the way If they are in same format and available in that field. If ok then it should work.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)