Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sergio0592
Specialist III
Specialist III

Issue with cursor using interval lenght

Hi all,

I have already dealt with cursor on integer field, but now i have to deal with cursor on intervall.

My chart contains a duration (mm:ss) and i when i create a cursor it don't works.

Nothing appears in my chart except if i select in my cursor Min_value=0 and Max_value=0. In this case, all values are displayed in the chart.

In the exemple below, i'd like display only districts with duration between 4  and 7 min.

Duration_chart.jpg

Regards


1 Solution

Accepted Solutions
sunny_talwar

Try this:

=If($(V_avg_duration) > vMin and $(V_avg_duration) < vMax, $(V_avg_duration))

Where vMin and vMax are two new variables

vMin: =MakeTime(0, V_min_value)

vMax: =MakeTime(0, V_max_value)

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Would you be able to share the sample with us to play around with?

sergio0592
Specialist III
Specialist III
Author

Here a sample. Sorry for the delay!

sunny_talwar

Try this:

=If($(V_avg_duration) > vMin and $(V_avg_duration) < vMax, $(V_avg_duration))

Where vMin and vMax are two new variables

vMin: =MakeTime(0, V_min_value)

vMax: =MakeTime(0, V_max_value)

Capture.PNG

sergio0592
Specialist III
Specialist III
Author

It works. Thanks to you