Discussion board where members can get started with QlikView.
I have a table consisting of category and dollar volume that I'd like to sort by dollar volume (desc), but would like to see the category of 'Other' to always be listed last. Is that possible to do?
Go to Solution.
Try an expression like this maybe?
if(Category = 'Other', 9999, rank(dollar volumn))
That worked, thanks so much!!!