Straight table mutiple dimension sort by expression

wenkew186 — Wed, 18 Mar 2015 15:47:51 GMT

Hi guys,

I have a problem need your help.

Question1: A straight table, 3 dimension(Dim1,Dim2,Dim3) and 3 expression (Exp1,Exp2,Exp3), Exp1 has positive and negative. so I want sort by FABS(Exp1) on Dim1. is this possible?

Question2: If it's possible, another question is the D1 have an irregular value '?',it is necessary and regular value is ID.

I think the "?" will impact sort result. how to solve it?

Re: Straight table mutiple dimension sort by expression

JonnyPoole — Wed, 18 Mar 2015 16:38:42 GMT

Yup. On the sort tab, ensure 'Dim1' is listed first and sort it by expression:

try the first and if not, the second

Sum( Fabs(Exp1))

aggr( sum(Fabs(Exp1)) , Dim1 )

topic Re: Straight table mutiple dimension sort by expression in QlikView

Straight table mutiple dimension sort by expression

Re: Straight table mutiple dimension sort by expression