Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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 ??
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 .
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!!
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
Thanks Vivek, Manuel and Johan for your answers.
What happen if there are more dourations for the same case id?
Don't know. I'm guessing the duration is for a case so it is a calculated value with totals,
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!