Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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?