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: 
JoannaManibo
Contributor II
Contributor II

Arranging Dimension Content in Bar Chart

I need help in arranging the dimension content without editing in Data Manager since I am currently building the dashboard by using codes in Data Load Editor due to multiple associations. 

Here's the list that I wanted to arrange:

1. Previous FY

2. FY-2015

3. FY-2016

4. FY-2017

5. FY-2018

6. FY-2019

7. 2019-Sep

8. 2019-Oct

9. 2019-Nov

 

Current Dashboard below:
Capture.JPG

Labels (2)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Use the match function in the sort section, depending on your dimension field name:

match(Period,'Previous FY', 'FY-2015', 'FY-2016', 'FY-2017', 'FY-2018', 'FY-2019', '2019-Sep', '2019-Oct', '2019-Nov')

View solution in original post

1 Reply
Lisa_P
Employee
Employee

Use the match function in the sort section, depending on your dimension field name:

match(Period,'Previous FY', 'FY-2015', 'FY-2016', 'FY-2017', 'FY-2018', 'FY-2019', '2019-Sep', '2019-Oct', '2019-Nov')