topic Re: Displaying cursor issue in QlikView

Displaying cursor issue

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two fields Duration1 and Duration2 associated with two cursors. I want display only rows not empty (value for Duration 1 and value for Duration2) regarding cursors selections. I don't know how to use my flag for filter rows.

See my sample in attached file.

Regards

Re: Displaying cursor issue

Anonymous — Thu, 29 Sep 2016 20:40:58 GMT

You are using a variable in the Slider/calendar object. If you Chose the Field Option and select the corresponding fields it should solve your problem.

In your case for Duration 1 Slider select the field Duration1 under General>Data>Field and for duration 2 slider select the field Duration 2

Re: Displaying cursor issue

sergio0592 — Thu, 29 Sep 2016 20:54:17 GMT

You're right, i made too tricky! However when i select field in the cursor, i can't choose the min and max value. How to manage this ??

Re: Displaying cursor issue

Anonymous — Thu, 29 Sep 2016 21:45:40 GMT

Glad that it worked

If you select the field option then min and mx will grey out.

Why would you need to give the min and max values?, Qlikview will automatically take the minimum and maximum value for that data point for example duration 1 will have minimum values 3 and 75.

Tomorrow if the maximum value is increased to 200 ,Qlikview will adjust it automatically .By this way your dashboard is scalable .

Re: Displaying cursor issue

Anonymous — Fri, 30 Sep 2016 06:45:41 GMT

Hi Sergio,

Change your table dimension by this:

=Aggr(If(Sum(if(Duration1>V_min_D1 and Duration1<V_max_D1, Duration1))>0 and Sum(if(Duration2>V_min_D2 and Duration2<V_max_D2, Duration2))>0,

Id_Case),Id_Case)

Check suppress value when is null:

Regards!!

Re: Displaying cursor issue

johanlindell — Fri, 30 Sep 2016 06:51:59 GMT

Or just add the calculated dimension:

If( Duration1>V_min_D1 and Duration1<V_max_D1 and Duration2>V_min_D2 and Duration2<V_max_D2, 1)

and "Suppress When Value Is Null" and hide it in the Presentation-tab.

// Johan

Re: Displaying cursor issue

sergio0592 — Fri, 30 Sep 2016 07:16:02 GMT

Thanks Vivek, Manuel and Johan for your answers.

Re: Displaying cursor issue

Anonymous — Fri, 30 Sep 2016 08:02:35 GMT

What happen if there are more dourations for the same case id?

Re: Displaying cursor issue

johanlindell — Fri, 30 Sep 2016 10:11:32 GMT

Don't know. I'm guessing the duration is for a case so it is a calculated value with totals,

Re: Displaying cursor issue

Anonymous — Fri, 30 Sep 2016 10:46:25 GMT

You have tu acumulate to prevent these cases, because you will have two or more rows, and expressions or calculated dimensions calling case id in if statement without acumulation will return null value.

Regards!

Re: Displaying cursor issue

sergio0592 — Mon, 03 Oct 2016 08:05:43 GMT

You're right Manuel, but Id_Case is Primary key. I carry on with my deals on slider and i'm facing to a new issue. I don't understand what's goes wrong.

In the attached .qvw sample i have three durations D1, D2, D3. I calculate average by district for each duration. When user select the duration associated with slider (see pic below)

chart rows must be filtered on this field. I made calculated dimension which works only when D1 is selected. And in another chart it works with D1 and D2, but i have too write two times condition for D2.

Re: Displaying cursor issue

johanlindell — Tue, 04 Oct 2016 08:31:33 GMT

Hi,

don't know why but it did not work. It looked to be OK. But changing and moving the condition to the expressions seems to work. Not sure what you want in the end but perhaps this is a step on the way to a solution. I modified it so that you can select one, two or all three "cursors".

//Johan

Re: Displaying cursor issue

Anonymous — Tue, 04 Oct 2016 11:33:05 GMT

Hi,

Vars are the same for min and max in D1, D2 and D3.

With this expression works:

=if((aggr((sum(Pick(Match(GetFieldSelections(_Select),'D1','D2','D3'),Duration1,Duration2,Duration3))/86400) / count(Id_Case),District) >V_min_D1 and aggr((sum(Pick(Match(GetFieldSelections(_Select),'D1','D2','D3'),Duration1,Duration2,Duration3))/86400) / count(Id_Case),District) <V_max_D1),1)

Your second dimension is not needed, you can use for district only:

Regards!

Re: Displaying cursor issue

sergio0592 — Tue, 04 Oct 2016 14:33:28 GMT

Indeed Manuel, use the fact that min and max values are same in D1,D2,D3 as you made is a very good idea . Thanks