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

Am using match() sort to arrange data but not working

Am using expression in the sort tab to sort my items in dimension but not working. what do I do?

1 Solution

Accepted Solutions
sunny_talwar

You have a parenthesis at the wrong spot, try this:

=Match([item text], 'Cupboards', 'Chairs', 'Building', 'PEE', 'Buriet', 'Isle', 'JV', 'Plastics', 'Desktop', 'System unit', 'Prints')


Capture.PNG

View solution in original post

26 Replies
sunny_talwar

What is the expression that you are using? Is it not working after you make a selection or it just doesn't work?

Not applicable
Author

It didn't work at all. I used =match(Field, ..,.,..,,.,..,)

sunny_talwar

It didn't work at all. I used =match(Field, ..,.,..,,.,..,)

What are those ..,..,..,? It would be helpful if you can post a sample or screenshot.

Not applicable
Author

I used "MATCH" statement and its not working

sunny_talwar

I understand that your Match() expression isn't working. But without knowing further details, I cannot guide you because I have no idea what you are doing incorrectly. Unless you have more to provide, I won't be able to help. I hope someone else might be able to.

Best,

Sunny

Not applicable
Author

Ok, I used if(match(Field, 'text','text'),Field) to pick specific items @ my dimension. Then wanna sort with =match(Field, 'text','text') to align what I actually want but not working.

settu_periasamy
Master III
Master III

Generally it would be like

=match(Dimensionname ,'5','B','A','1')

Try to change the value 5,B, A and 1 based on your need..

But, if you give your full expression in sort, we can help you..

Not applicable
Author

I did, didn't work

settu_periasamy
Master III
Master III

Understood..that's why you posted. but how do we know why it is not working without more detail..

Could you please post a small amount of sample data?