Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ritumishra01
Contributor III
Contributor III

bar chart representation

i want to change the order  of bars

submitted

under-review 

in-progress

ritumishra01_0-1692700793212.png

how can i achieve that .

Labels (1)
1 Solution

Accepted Solutions
Zapparoli
Creator II
Creator II

Hi @ritumishra01 

You can specify a custom order for your dimension using the Match() Function:

In the sort tab of your dimension, check "sort by expression"

Matheus_Zapparoli_0-1692712437941.png

And use this Formula:

match(Status, 'submitted', 'under-review','in-progress')

With this you can do any order that you want.

Let me know if it helps.

-Zapparoli

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

View solution in original post

2 Replies
salonicdk28
Creator II
Creator II

Hi,

Apply sorting based on the order (ascending or descending) required under sorting section 

Zapparoli
Creator II
Creator II

Hi @ritumishra01 

You can specify a custom order for your dimension using the Match() Function:

In the sort tab of your dimension, check "sort by expression"

Matheus_Zapparoli_0-1692712437941.png

And use this Formula:

match(Status, 'submitted', 'under-review','in-progress')

With this you can do any order that you want.

Let me know if it helps.

-Zapparoli

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics