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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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