Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

sanjay006
Contributor

Shorting In Dimension

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.

21 Replies
sanjay006
Contributor

Re: Shorting In Dimension

@Peter Cammaert

vinieme12
Esteemed Contributor II

Re: Shorting In Dimension

See attached, updated file

260492.PNG

sanjay006
Contributor

Re: Shorting In Dimension

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

vinieme12
Esteemed Contributor II

Re: Shorting In Dimension

The comments in your QVW is different to the post above

Capture.PNG

vinieme12
Esteemed Contributor II

Re: Shorting In Dimension

See attached updated version

sanjay006
Contributor

Re: Shorting In Dimension

but why are you changing the dimension.

please short this dimension

=Dual(Company,Aggr(Sum(Count),MetricID,Company))

sanjay006
Contributor

Re: Shorting In Dimension

Dimension 1  : =if(not(match(MetricID,3,4)),MetricID)

Dimension 2  : =Dual(Company,Aggr(Sum(Count),MetricID,Company))


expression  :    sum(Count)

vinieme12
Esteemed Contributor II

Re: Shorting In Dimension

Buddy the dimension is already sorted without this expression.

sanjay006
Contributor

Re: Shorting In Dimension

Yes it is but it is not the actual dimension that i wanted to short.it is having more attributes than before.

Community Browser