"How to find next/previous value of the field?" with scientific values?

[Pawel_Snarski]

Hello fellow developers.

I've got inspired by the following post:

Solved: How to find next/previous value of the field? - Qlik Community - 831644

Therefore, I've tried to apply the very same filter in my case. However, I run into a trouble of having dimension values specifically designed to have 14 digits.

Let's assume I have the following table:

load * Inline [
TransID
20030814000020
20030814000021
20030814000022
20030814000023
20030814000024
20030814000035
20030814000040
20030814000041
20030814000042
];

When I select the very first id = 20030814000020
and try to visualize the very next id with the following syntax:
Subfield(Concat({<[TransID]={">$(=[TransID])"}>} DISTINCT [TransID],',',[TransID]),',')

I won't get 20030814000021 but 20030814000023

Any help is much appreciated. Trust me, I've tried a lot, like:
Dual([TransID],Evaluate([TransID])) or Num([TransID],'dec')

Best Regards,
Pawel

[Chanty4u]

Try this

Subfield(

    Concat({< TransID = {"<$(=TransID)"} >} DISTINCT TransID, ',', TransID),

    ','

)

[Pawel_Snarski]

Have you actually tried that in the App?

[Rohan]

Hi @Pawel_Snarski ,

Just do one small check in your load script; Add Ordering to your TransactionID Column preferrably Asc & then try the front end part.

Regards,

Rohan.

[Pawel_Snarski]

Hi @Rohan , thank you for your input. However, it didn't change anything.