topic Error in calculated dimension for a dynamic bucket in QlikView

Error in calculated dimension for a dynamic bucket

dafnis14 — Sat, 16 Nov 2024 04:04:22 GMT

Hi,

I'm trying to define a calculated dimension based on the solution offer here by @effinty2112 :

https://community.qlik.com/t5/New-to-QlikView/Dynamic-bucket/td-p/1435684

The limit of each bucked ise dynamic.

My expression works fine in a text box, but generates an error when I try to use it for a calculated dimension.

Any idea why?

=Pick(Match(-1,

sum(SalesOrder_Line_Part_Qty) < vLimit1,
sum(SalesOrder_Line_Part_Qty) < vLimit2,
sum(SalesOrder_Line_Part_Qty) < vLimit3,
sum(SalesOrder_Line_Part_Qty) < vLimit4,
-1),

'<='& vLimit1,
'<=:'&vLimit2,
'<=:'&vLimit3,
'<=:'&vLimit4)

Thanks in Advance!

Re: Error in calculated dimension for a dynamic bucket

dafnis14 — Fri, 22 Mar 2019 16:59:00 GMT

I got an idea from a solution offered by @Oleg_Troyansky :

http://www.naturalsynergies.com/q-tip-14-aggr-and-synthetic-dimensions/

So I've modified the expression to include AGGR() :

=Pick(Match(-1,

aggr(sum(SalesOrder_Line_Part_Qty),SalesOrder_Line_PartID) <= vLimit1,
aggr(sum(SalesOrder_Line_Part_Qty),SalesOrder_Line_PartID) <= vLimit2,
aggr(sum(SalesOrder_Line_Part_Qty),SalesOrder_Line_PartID) <= vLimit3,
aggr(sum(SalesOrder_Line_Part_Qty),SalesOrder_Line_PartID) <= vLimit4,
-1),

'<='& vLimit1,
'<=:'&vLimit2,
'<=:'&vLimit3,
'<=:'&vLimit4)

Thank you Oleg!