topic Re: Sorting a straight table with a not-visible field in App Development

Sorting a straight table with a not-visible field

nikolaus — Thu, 05 Oct 2023 06:06:17 GMT

Hello,

I am working for some years now with QlikView and QlikSense. I recognized that in QlikSense the sorting of table can be done by ordering fields in the Sorting section. This works fine.

But I was not able to sort a table with a field, that is not visible on the screen.

e.g. customer data. The table should be sorted by a field call matchcode that should not be visible. At the same moment I remove the field (by setting show column if 0=1) the sorting is gone. It does not matter that I set the sorting for the first column to "sort by expression" and the expression to matchcode.

How do you solve this?

Thanks

Niko

Re: Sorting a straight table with a not-visible field

JHuis — Thu, 05 Oct 2023 06:14:49 GMT

this will do the trick:

https://help.qlik.com/en-US/video/bSN7z04pFqM

Re: Sorting a straight table with a not-visible field

nikolaus — Thu, 05 Oct 2023 06:19:19 GMT

Thanks for the quick respone. Unfortunatly - I don´t get it. This is the first colum in the table, all other sortings are removed. It does not sort by that (invisible) field.

Re: Sorting a straight table with a not-visible field

JHuis — Thu, 05 Oct 2023 06:24:57 GMT

I dont know if it is an nummeric or text field.

But you can use MinString(YOURFIELD)

or Min(YOURFIELD)

Re: Sorting a straight table with a not-visible field

Cascader — Thu, 05 Oct 2023 06:36:03 GMT

In qlikview, I use this work around, I set the field text color to =rgb(255,255,255)

and I put in label =''

Re: Sorting a straight table with a not-visible field

nikolaus — Thu, 05 Oct 2023 06:36:04 GMT

Its a text field. MinString([Kunden.KndKurzBez]) is simply ignored.

I am puzzled that this is difficult at all.

Re: Sorting a straight table with a not-visible field

nikolaus — Tue, 10 Oct 2023 17:18:19 GMT

Just for complitements sake: Its not possible. This is very, very frustrating. A statement by Qlik would be very welcome.