topic Y-Value Sort or Dimension Value in QlikView

Y-Value Sort or Dimension Value

Fri, 10 Jul 2009 21:16:45 GMT

Hi Folks

I have a chart that has a cyclic dimension, most of these dimensions are items such as region, country, fund type etc which should be sorted by value in descending order (Y-Value Descending), however, one of the dimensions is a Year Purchased and when this dimension is active we want to sort in Year order.

Does anybody know how I can do this in a sort expression (i.e. IF ( DIM='Year' , YearNumber , Y-Value )

Note: I cannot put the expression itself into the statement above because the expression is a cyclic one.

Cheers,

Y-Value Sort or Dimension Value

stephencredmond — Fri, 10 Jul 2009 21:23:14 GMT

Hi Nigel,

The GetCurrentField function will tell you what is the current field for your Group.

Stephen

Y-Value Sort or Dimension Value

Fri, 10 Jul 2009 21:45:45 GMT

Hi Stephen

The problem is that when you set up a cyclic group on EXPRESSIONS, there is no group name so you cannot access the group and therefore cannot use the GetActiveField or GetCurrentField functions.

Pretty sure I'm correct in this one anyway.

Cheers,

Y-Value Sort or Dimension Value

stephencredmond — Fri, 10 Jul 2009 22:20:15 GMT

Yes,

To be honest, I have always avoided this issue by separating series that are "Y" sorted from those that are ordinal sorted into different charts. I normally have a practice of using Bars for the former and Lines for the later anyway so it makes sense to me.

Regards,

Stephen