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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Placement of rows in QV report

Hi guys,

I am creating a report where certain rows supposed to appear in a certain sequence but QV always sorts them.

For example...

my report looks like

COST

          100

Expense

          500

Income

          1000

But I want it look like

Income

     1000

Cost

     100

Expense

     500

Is it possible to do in QV?

Regards,

Saurabh

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can assign your dimension values a dual value using the dual() function, then sort your dimension numeric on sort order tab. Or use an expression to sort:

=match(DIMENSIONFIELD,'Income','Cost','Expense')

View solution in original post

1 Reply
swuehl
MVP
MVP

You can assign your dimension values a dual value using the dual() function, then sort your dimension numeric on sort order tab. Or use an expression to sort:

=match(DIMENSIONFIELD,'Income','Cost','Expense')