topic Order alphabetically with a expression in QlikView

Order alphabetically with a expression

cristian_av — Thu, 01 Mar 2018 18:24:29 GMT

I have a field called %OrderType, which has values KG or Box. What I want is that when the user select KG or Box, a dimension of a graph is orderer by an expression. This is working. But if there is no expression selected, I want the dimension to be ordered alphabetically.

The dimension is "Especie" and this is the expression that I am using:

=if(%OrderType='KG',Sum(#Kg)/1000,

if(%OrderType='Box',Sum(#Box)/1000,

[Especie])))

Any idea about how to order alphabetically is nothing is selected?

Thanks!

Re: Order alphabetically with a expression

sunny_talwar — Thu, 01 Mar 2018 18:30:07 GMT

May be this

=If(%OrderType = 'KG',Sum(#Kg)/1000, If(%OrderType = 'Box', Sum(#Box)/1000, (Count(DISTINCT [Especie]) - Rank([Especie]))))

Re: Order alphabetically with a expression

cristian_av — Thu, 01 Mar 2018 20:25:02 GMT

I've found an easier way:

=if(%OrderType='KG',Sum(#Kg)/1000,

if(%OrderType='Box',Sum(#Box)/1000,

null() )))

And select the order alphabetically in the GUI

Thanks!