Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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')