Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
scholar1
Contributor II
Contributor II

Text Box Count

Hi Guys,

I have the below expression In a Text Box. Basically I only want to count the HIST_TOTAL (Total Number of Errors) where the HIST_DATE_DTTM_DAY  = Todays Date. HIST_TOTAL has errors from numerous dates but I just want my expression to count the latest date.   I've tried to use the Today() function in the expression but it doesn't seem to be working.

='Current No of Errors
' &
Round(count({<HIST_DATE_DTTM_DAY={Today}>}HIST_TOTAL)) 

I'm sure this is simple to resolve so any suggestions would be great.

Cheers,

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

='Current No of Errors
' &
Round(count({<HIST_DATE_DTTM_DAY={'$(=Today())'}>} HIST_TOTAL))


Assuming that HIST_DATE_DTTM_DAY shows dates in default date format.

View solution in original post

3 Replies
pokassov
Specialist
Specialist

Hi!

='Current No of Errors
' &
Round(count({<HIST_DATE_DTTM_DAY={'$=(date(Today()))'}>}HIST_TOTAL),1)

swuehl
MVP
MVP

Try

='Current No of Errors
' &
Round(count({<HIST_DATE_DTTM_DAY={'$(=Today())'}>} HIST_TOTAL))


Assuming that HIST_DATE_DTTM_DAY shows dates in default date format.

scholar1
Contributor II
Contributor II
Author

Hi Swuehl,

This seems to work well.

Thank You