get previously selected value of listbox

[#1]

Hi,

I have a listbox with values One, Two, Three.

If i select One, then it will be the current selection.

After that if i select Two, then One will be the Previous selection.

I want to get the previously selected value of a listbox in a variable or in text object.

ie., One as the value.

How can we get that?

I tried like

Only({$1} FieldName)

It is giving me the currently selected value, but i want the previously selected value of a listbox.

[#2]

try this:

LOAD * INLINE [

Number, Amount

1, 40

2,50

3,60

];

Expression:

=sum({$1} Amount)

[#3]

Hi Thomas,

Mine is a text field. so it is giving me the selected value.

It is not giving me the previous value.

I tried like this

Load * inline [

Field1,Field2

1,One

2,Two

3,Three

];

In a text object, i tried Sum({$1} Field1)

It is giving me 1, if i select One, 2 when i select Two

[#4 · Accepted solution]

this works fine:

When you first make the chart it will show all three- because there is no previous.

[#5]

Hi thomas,

The file which you gave, its working fine.

but the same object i copied to my file, it is not working.

I wonder, how it is happening?

[#6]

maybe because it still has a reference to my document. Create by yourself then you are sure that it works

[#7]

Hi thomas,

I tested my application.

It works only when few tables are loaded from QVD and this inline table.

I have around 15 tables from QVD. If i load all the tables and with this inline table, it is not working.

What kind of issue is this?

This inline is not linked to any other table.