Sorting values extracted with block "List Values Of Field"

Sven2 — Wed, 25 Oct 2023 20:03:16 GMT

Hi,

I'm struggling to sort values that I extracted with the "List Values Of Field" block from my app. The values are in field qText.

I have right now: Orange, Banana, Apple, Strawberry

I would like to have: Apple, Banana, Orange, Strawberry

I'm using a "Transform List" block with the list function "Sort".
This is the input:
{ "list": [ { "qText": "Orange", "qNum": "NaN", "qElemNumber": 0, "qState": "O" }, { "qText": "Banana", "qNum": "NaN", "qElemNumber": 1, "qState": "O" }, { "qText": "Apple", "qNum": "NaN", "qElemNumber": 2, "qState": "O" }, { "qText": "Strawberry", "qNum": "NaN", "qElemNumber": 3, "qState": "O" } ]

The output is this:

[ { "qText": [ { "qText": "Orange", "qNum": "NaN", "qElemNumber": 0, "qState": "O" }, { "qText": "Banana", "qNum": "NaN", "qElemNumber": 1, "qState": "O" }, { "qText": "Apple", "qNum": "NaN", "qElemNumber": 2, "qState": "O" }, { "qText": "Strawberry", "qNum": "NaN", "qElemNumber": 3, "qState": "O" } ] }, { "qText": [ { "qText": "Orange", "qNum": "NaN", "qElemNumber": 0, "qState": "O" }, { "qText": "Banana", "qNum": "NaN", "qElemNumber": 1, "qState": "O" }, { "qText": "Apple", "qNum": "NaN", "qElemNumber": 2, "qState": "O" }, { "qText": "Strawberry", "qNum": "NaN", "qElemNumber": 3, "qState": "O" } ] }, { "qText": [ { "qText": "Orange", "qNum": "NaN", "qElemNumber": 0, "qState": "O" }, { "qText": "Banana", "qNum": "NaN", "qElemNumber": 1, "qState": "O" }, { "qText": "Apple", "qNum": "NaN", "qElemNumber": 2, "qState": "O" }, { "qText": "Strawberry", "qNum": "NaN", "qElemNumber": 3, "qState": "O" } ] }, { "qText": [ { "qText": "Orange", "qNum": "NaN", "qElemNumber": 0, "qState": "O" }, { "qText": "Banana", "qNum": "NaN", "qElemNumber": 1, "qState": "O" }, { "qText": "Apple", "qNum": "NaN", "qElemNumber": 2, "qState": "O" }, { "qText": "Strawberry", "qNum": "NaN", "qElemNumber": 3, "qState": "O" } ] } ]

What settings should I use? or is there a better way to do this?

Thanks for any help!

Re: Sorting values extracted with block "List Values Of Field"

Shai_E — Mon, 30 Oct 2023 08:54:24 GMT

Hi @Sven2 ,

I will send you a workspace example of a working example that i created.

Best Regards

Re: Sorting values extracted with block "List Values Of Field"

Sven2 — Mon, 30 Oct 2023 18:14:10 GMT

Thank you @Shai_E!

Your example made me realize that I must have encountered a bug in the Automation editor as I didn't see the selection list that asks if I want the first item, all items or the last item from the "List Values of Field" block.

Today I see this and it works as expected.

Best,

Sven

topic Re: Sorting values extracted with block "List Values Of Field" in Qlik Automate

Sorting values extracted with block "List Values Of Field"

Re: Sorting values extracted with block "List Values Of Field"

Re: Sorting values extracted with block "List Values Of Field"