Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort expression

HI,

I have a problem with sort express. How should look expression?

The sort order is ROZ, ZAW, W, PRZYPISANY

THANKS

MARTA

8 Replies
sunny_talwar

May be like this

Match(FieldName, 'ROZ', 'ZAW', 'W', 'PRZYPISANY')

nagarjuna_kotha
Partner
Partner

This is Information is not enough and not clear.

Can u explain clearly with some some sample data along with output.

-Nagarjun

Not applicable
Author

I have something like this

STATUS: ZAWIESZONY, PRZYPISANY_DO_GRUPY, ROZWIAZANY, W_TRAKCIE_PRAC

I wants to sort like this: ROZWIAZANY, ZAWIESZONY, W_TRAKCIE_PRAC, PRZYPISANY_DO_GRUPY

But I do not know how sort expression

sunny_talwar

This?

=Match(STATUS, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')

squeakie_pig
Creator II
Creator II

It is like Sunny T said.

Go to the object properties.  Click the sort tab.  Click on the field you want to sort by... add the expression

match(YOURFIELDNAME, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')

choose either ascending or descending, depending on how you want it to sort.

muthukumar77
Partner
Partner

Hi,

Go to Sort expression,put like this,

If(YOURFIELDNAME='ROZWIAZANY',1,

If(YOURFIELDNAME='ZAWIESZONY',2,

If(YOURFIELDNAME='W_TRAKCIE_PRAC',3,

If(YOURFIELDNAME='PRZYPISANY_DO_GRUPY',4))))


set as Ascending order.

Muthukumar Pandiyan
Not applicable
Author

All of these solutions not work

sunny_talwar

Would you be able to share a sample to look at what you are trying to do?