Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks a Lot dear .. It Worked...
Thanks a lot , it worked