Discussion board where members can get started with QlikView.
I did that but i want the sorting in same manner as in bar chart which goes wrong when i converted it to straight table.
Converted? It all depends on how your data is structured, but there shouldn't be a reason why a bar chart can't become a straight table - you could simply turn on the fast change option and enable both to allow switching between the two? You can have cyclic dimensions in a straight table.
Thanks . It helped me but now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.
Thanks anbu. But i think Aron reply is more helpful. But now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.
Actually, in barchart i have cyclic dimensiona nd cyclic expression. There it is sorting in correct manner by both ways.
When i create cyclic dim and expr in straight table, it is not working correctly.
Can you post your .qvw or show a screenshot of what you're using in the sort tab? Are you using an expression or just sorting by default values? Are they numbers?
I can not post qvw. But ltme tell you:
Cyclic dim = User + Country + Department
Cyclic Expression = Expr 1 + Expr2
Under Sort tab:
1: For Cyclic Dim: I checked Frequency : Descending
2: For very first expr: i checked Numeric value = Descending
But they are not coming correct order.
What are you expecting to see? And what is it showing? Can you give an actual example of the data?
Be aware that sorting your dimension by frequency is equivalent to a count of the expression.