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?

26 Replies
sunny_talwar

I think it must be a typo since this is a dimension and it seems from OPs posts that dimension is working, but the sorting isn't. I guess we have prescribed all possible things, a easier and more efficient way would be to provide a sample if you can.

sunny_talwar

See if the attachment can guide you

Capture.PNG

Not applicable
Author

No that script worked. I picked the specified item I wanted

Not applicable
Author

I used nested IF to pick my items at dimension

sunny_talwar

Please clarify what exactly are you doing, else we will never we able to resolve your request.

1) What is the exact expression (word to word match) you are using for your dimension?

2) What is the exact expression (word to word match) you are using for your sort expression?

Not applicable
Author

Please can you send email addr plz?

Not applicable
Author

I used

about 10 statement to callup my dimension items

IF(match(....

IF(match(.......

IF(match(.........

...

IF(match(.......

How do I sort it now?