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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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
Champion III
Champion III

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.