Displaying cursor issue

[sergio0592]

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

[sergio0592]

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.

[johanlindell]

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

[Anonymous]

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:

=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),District)

Regards!

[sergio0592]

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