Create List Box

[#1]

I am trying to generate a dash board which should display the total amount based on selection

My data is

Type1	Bal_Before Adj	Adjustment	Final
A	10	0	10
B	20	0	20
C	30	5	35

I need to create a List Box showing “Before Adj” and “After Adj” and

While selecting “Before Adj” I need to display Column 2 whereas while selecting “After Adj” I need column 4

[Gysbert_Wassenaar · Accepted solution]

Create a table BeforeAfter in the load script:

BeforeAfter:

LOAD * Inline [

BeforeAfter

Before

After

];

Add a listbox for the new field BeforeAfter. Set the expression for Conditional for Bal_Before Adj to match(BeforeAfter,'Before') and set the expression for Conditional for the expression for Final to match(BeforeAfter,'After'). See attached qvw.

[#3]

Thanks a Lot dear .. It Worked...

[#4]

Thanks a lot , it worked