Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis for Between timings

Hi ,

        I have "Name" field and "time" field. I m calculating Count of names in between 30 mins to 1 hour and using "Client"  Field as Dimension

i have written expression like this:

Count({<Time1={'>=(00:30:00) <=(01:00:00)'},Category={'MPLS'}>}Name)

it is not working.

Any Suggestions Would be greatly appreciated

Regards,

Divya

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If your time format is 'hh:mm:ss', try

=Count({<Time1={">=00:30:00<=01:00:00"},Category={'MPLS'}>} Name)


or post a small sample app or some lines of sample data.

View solution in original post

1 Reply
swuehl
MVP
MVP

If your time format is 'hh:mm:ss', try

=Count({<Time1={">=00:30:00<=01:00:00"},Category={'MPLS'}>} Name)


or post a small sample app or some lines of sample data.