Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
gopinadhpindra
New Contributor II

count expression is not working

Hi team,

The below expression is not working because of timestamp issue's  please find the dummy data and correct me

Spoiler
 

=count({$<State={'Resolved','Closed'},Opened={">=$(=text(date(min(Opened))))<=$(=text(date(max(Opened))))"}>}Number)

1 Reply
Frank_Hartmann
Honored Contributor

Re: count expression is not working

Try this:

=count({$<State={'Resolved','Closed'},Opened={">=$(=Timestamp(date(min( Opened))))<=$(=Timestamp(date(max( Opened))))"}>}Number)