topic Re: Min / Max with Slider in QlikView

Min / Max with Slider

tmumaw — Sat, 16 Nov 2024 02:36:10 GMT

Need a little help with my min max calculation. Does anyone see a problem with it? This is a calculated dimension. Thanks

if(aggr(sum({<DDDC_Days = {"< 0"}>} DDDC_Cnt),[PC Desc]) /
    aggr(sum(EmployeeCnt),[PC Desc]) >= $(vMin),[PC Desc] and
   (aggr(sum({<DDDC_Days = {"< 0"}>} DDDC_Cnt),[PC Desc]) /
    aggr(sum(EmployeeCnt),[PC Desc]) <= $(vMax),[PC Desc])

Re: Min / Max with Slider

m_woolf — Thu, 29 Aug 2019 19:10:18 GMT

I think the red parenthesis at the start of the third line should be removed.

Re: Min / Max with Slider

marcus_sommer — Fri, 30 Aug 2019 14:21:50 GMT

Are you sure that you need all these aggr? All have the same dimension and therefore the following might be working, too:

aggr(if(
   sum({<DDDC_Days = {"< 0"}>} DDDC_Cnt) /
   sum(EmployeeCnt) >= $(vMin) and
   sum({<DDDC_Days = {"< 0"}>} DDDC_Cnt) /
   sum(EmployeeCnt) <= $(vMax),[PC Desc]),[PC Desc])

- Marcus

Re: Min / Max with Slider

tmumaw — Wed, 04 Sep 2019 14:29:18 GMT

Thanks. Worked perfect.