topic Re: Text Box Count in QlikView

Text Box Count

Anonymous — Wed, 23 Sep 2015 14:49:57 GMT

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,

Re: Text Box Count

pokassov — Wed, 23 Sep 2015 14:51:28 GMT

Hi!

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

Re: Text Box Count

swuehl — Wed, 23 Sep 2015 14:52:47 GMT

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.

Re: Text Box Count

Anonymous — Wed, 23 Sep 2015 14:56:08 GMT

Hi Swuehl,

This seems to work well.

Thank You