Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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)