Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
datalakeyu
Valued Contributor

How to sort by Expression in Qlik Sense?

I used one filter in Qlik sense sheet.

The filter includes city names: Chicago, Boston, Seattle.

I need show the city name in order: Chicago, Boston, Seattle.

How could I keep the city name in above order in the Qlik sense filter?

Or is it possible to sort by Expression to get the above order in Qlik Sense?

Thanks for your help!

1 Solution

Accepted Solutions
datalakeyu
Valued Contributor

Re: How to sort by Expression in Qlik Sense?

Use Qlik Match function. For example:

Match(Column_name,
                'Chicago', 
                'Boston',
                'Seattle'
      )

1 Reply
datalakeyu
Valued Contributor

Re: How to sort by Expression in Qlik Sense?

Use Qlik Match function. For example:

Match(Column_name,
                'Chicago', 
                'Boston',
                'Seattle'
      )