topic Re: Sort expression in QlikView

Sort expression

Wed, 25 Nov 2020 16:16:04 GMT

HI,

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

The sort order is ROZ, ZAW, W, PRZYPISANY

THANKS

MARTA

sunny_talwar — Mon, 05 Dec 2016 11:06:15 GMT

May be like this

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

nagarjuna_kotha — Mon, 05 Dec 2016 11:07:42 GMT

This is Information is not enough and not clear.

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

-Nagarjun

Mon, 05 Dec 2016 11:29:51 GMT

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 — Mon, 05 Dec 2016 12:13:57 GMT

This?

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

squeakie_pig — Mon, 05 Dec 2016 12:18:12 GMT

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 — Mon, 05 Dec 2016 17:42:10 GMT

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.

Tue, 06 Dec 2016 06:00:36 GMT

All of these solutions not work

sunny_talwar — Tue, 06 Dec 2016 10:13:29 GMT

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