Discussion Board for collaboration regarding Qlik DataMarket.
i am trying to short the second dimension. I have tried all the possible way to short.
Short the second dimension alphabetical order.
Thank's in advance.
See attached, updated file
Sir previously it was showing the less dimensions and now it's more. And instead of this I want the dimension to be shorted alphabetically not the expression by number.
from A-Z or Z-A
The comments in your QVW is different to the post above
See attached updated version
but why are you changing the dimension.
please short this dimension
Dimension 1 : =if(not(match(MetricID,3,4)),MetricID)
Dimension 2 : =Dual(Company,Aggr(Sum(Count),MetricID,Company))
expression : sum(Count)
Buddy the dimension is already sorted without this expression.
Yes it is but it is not the actual dimension that i wanted to short.it is having more attributes than before.