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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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