topic Re: Create List Box in QlikView

Create List Box

Sun, 18 Nov 2012 08:47:49 GMT

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

Re: Create List Box

Gysbert_Wassenaar — Sun, 18 Nov 2012 09:18:28 GMT

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.

Re: Create List Box

Sun, 18 Nov 2012 09:31:08 GMT

Thanks a Lot dear .. It Worked...

Re: Create List Box

Sun, 18 Nov 2012 09:31:36 GMT

Thanks a lot , it worked