topic Re: Issue with cursor using interval lenght in QlikView

Issue with cursor using interval lenght

sergio0592 — Wed, 21 Sep 2016 15:44:46 GMT

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.

Regards

sunny_talwar — Wed, 21 Sep 2016 16:18:27 GMT

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

sergio0592 — Wed, 28 Sep 2016 10:09:49 GMT

Here a sample. Sorry for the delay!

sunny_talwar — Wed, 28 Sep 2016 17:16:17 GMT

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)

sergio0592 — Thu, 29 Sep 2016 07:18:20 GMT

It works. Thanks to you