Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sorting a dimension

I want to sort a dimension in a particular order.

F Account

C Account

R Account

It seems that none of the pre defined Sort by options allow this.

Can someone help with an expression that I can enter to sort in this order?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Sorting a dimension

Try a sort expression like

=match(DIMENSION, 'F Account','C Account','R Account')

2 Replies
MVP
MVP

Re: Sorting a dimension

Try a sort expression like

=match(DIMENSION, 'F Account','C Account','R Account')

Not applicable

Re: Sorting a dimension

Exactly what I wanted. Thank you very much!